glennraskin
New Member
- Joined
- Sep 7, 2006
- Messages
- 2
I am finding some limitations I cant seemt to get around for the Excel graphics. I've been able to do conditional (make any given column a different color) graphing by overlappping one column onto another. I do this by changing the overlap % to 100% for a two column chart and having an if statement in the dataset that makes the value of the 2nd column either 0 if I don't want it to show up or = to the value of the firstr entry if I want it to show up instead of the original data set. The net affect is a single column with a conditional coloring.
That said, now I want to have two side by side columns - one that always shows and the second to be conditional as done above....The same solution does not work here because I want 2 or more columns to be visible. My chart has 3 possible columns of which I want to show 2, but the problem is that the overlap setting is common for all columns...
Does anyone know how to have different overlap settings for each data entry line ? I'd like the overlap of Column 2 on Column 1 to be 0% and Column 3 on Column 2 to be 100%...
Thanks,
glenn
That said, now I want to have two side by side columns - one that always shows and the second to be conditional as done above....The same solution does not work here because I want 2 or more columns to be visible. My chart has 3 possible columns of which I want to show 2, but the problem is that the overlap setting is common for all columns...
Does anyone know how to have different overlap settings for each data entry line ? I'd like the overlap of Column 2 on Column 1 to be 0% and Column 3 on Column 2 to be 100%...
Thanks,
glenn