Challenges with Conditional Charting in Excel

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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Ben,

Thanks for the welcome ! :biggrin:

Your idea would work in excel, but unfortunately I don't think my application could use it... to explain -
The end user is comparing the first two columns height against each other and wants the 2nd column to be conditionally formatted. If I stacked the first 2 columns, they'd lose the visual comparison.

Thanks
Glenn
 
Upvote 0
glenn.

i guess i'm a little confused. are you using excel for this? if so, you can create a chart which includes multiple chart types (one per series). you can do this by right-clicking on the series, going to chart type, and changing it to whatever type you want.

hope this helps.
ben.
 
Upvote 0

Forum statistics

Threads
1,207,387
Messages
6,078,200
Members
446,321
Latest member
thecachingyeti

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top