Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 8
Impact
~9k people reached

Feb
10
comment How to change the colours of sparkline axes individually
Note that if you do this and want to use the doc code example I posted then change "A2:C2" to either "A21" or ``"A21:F21"` or anything in between, it won't matter. Also change ... = Range("A8").Interior.Color to ... = RGB(255,0,0) for example
Feb
10
comment How to change the colours of sparkline axes individually
Thanks. In cells A1:F20 make some random data that crosses 0 (e.g. =randbetween(-10,10)). Then in cells A21:F21 make a normal sparkline that references A1:F20 for data. Use any rules you like to choose which sparklines should have a different coloured axis.
Feb
10
comment How to change the colours of sparkline axes individually
@Raystafarian but the items are not in a collection so do you know how to iterate over them?
Feb
10
comment How to change the colours of sparkline axes individually
@Raystafarian thanks, I know that. I only have one group. One single group. The code comes straight out of the docs (linked), and in their example they have 3 groups. I only have 1. 1 group, containing 60 sparklines. If I had 60 groups each containing 1 sparkline then yes, the foreach would iterate through them all. This is why I would happily accept an answer that shows me how to break 1 group of 60 sparklines into 60 groups of 1 sparkline each. I have 1 group of 60 because that requires making the sparkline manually once. 60 groups of 1 means making 60 sparklines manually.
Feb
10
comment How to change the colours of sparkline axes individually
I only have one group, in this group there are multiple spark lines (i.e. many cells). I want to change the colour of the axis for individual sparklines with-in this one group. If you can help me break this one group into one group per sparkline, then yes I can use an if statement to achieve what I want.
Feb
10
comment How to change the colours of sparkline axes individually
@Raystafarian no you can't change the axis colour manually unfortunately. You can't even change them as a group manually, which is why the docs provide the vba code linked to.
Feb
10
comment How to change the colours of sparkline axes individually
I've inspected the objects in the above code in the watch window while debugging and found no way to alter individual item properties. And I've search for documentation about splitting the groups and found nothing.
Nov
17
comment Query parameters in an external connection to sql server
Finally got a chance to do this, sorry it took so long! This works!!! My only suggestion would be to expand on point 3 as in my case I didn't have the connection set up and I'm not sure for example between SQL Server or SQL Server native client 11.0 etc. Otherwise great answer!
Sep
12
comment Google Chrome is adding a slash to my searches
@Cory I reported it as an issue to Chrome asking them to make an exception if this is indeed a new feature. Perhaps you should too. Under the chrome menu -> Help -> Report Issue
Sep
11
comment Google Chrome is adding a slash to my searches
I have this same issue, does this come from a recent chrome update? I'm sure I did not used to experience this. It's extremely irritating
May
23
comment Query parameters in an external connection to sql server
@PeterMunnings Would you mind writing up the full procedure you used to get it working with a simple query as an answer please?
May
23
comment Query parameters in an external connection to sql server
@PeterMunnings I couldn't find any other way besides using VBA. Although in the end we stuck with a button rather than a cell change trigger to make it more obvious that there is VBA behind it
Feb
14
comment Page appears centered at 120% zoom but on the left at 100%
just tried that. No good for me I'm afraid :(
Feb
14
comment Page appears centered at 120% zoom but on the left at 100%
A colleague has the identical screens to me, same resolution, but his is centered by default.
Feb
14
comment Page appears centered at 120% zoom but on the left at 100%
But how do I make this the default behaviour? If I do this, then I can zoom with the mouse wheel (holding control) and it stays centered, but if I click on that zoomy bar in the bottom right then it reverts back to the left.
Jan
28
comment How to link N*M cells in MS-excel? (F4 function for $ in a matrix)
So click on cell A1, press F4, and then drag it down and across.
Jan
28
comment How to link N*M cells in MS-excel? (F4 function for $ in a matrix)
Is this a single array formula? Is it a formula that has been auto-filled (dragged down)? Or are these completely independent formulae?
Nov
19
comment Excel Multiplication
@MatthewS. you should use multiple columns as J_D says. For example keep your original values in ColA, your multipliers in ColB (so can easily be unique for each row) and then in ColC it's just =A1*B1. Then you can just find the average of ColC
Aug
15
comment Query parameters in an external connection to sql server
@DaveRook Yes I've tried it, for OLE DB drivers it looks like there just isn't an option for parameters. The button is greyed out. My approach is fine but what a mission to write a bunch of macros when Excel can probably do it for me. Plus macros are less robust, if I move the cell then I have to go and manually change all the references in the code.
May
7
comment How to locate Matlab installation?
It means open Matlab and type matlabroot inside matlab I would think