| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Overlapping Bars Chart & Two Y Axes: how?
I can create bar and column charts w/ 2 data sets slightly overlapping.
However, when I add a secondary Y axis, the two sets of bars completely overlap w/ no offset possible -- at least not that I can figure out. Is there a way to have my cake and eat it too, that is, have two Y axes and a slight overlap of the bars? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Overlapping Bars Chart & Two Y Axes: how?
Hi,
You need to change the layout of your data in order to have column chart with 2 axes. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy Jay wrote: I can create bar and column charts w/ 2 data sets slightly overlapping. However, when I add a secondary Y axis, the two sets of bars completely overlap w/ no offset possible -- at least not that I can figure out. Is there a way to have my cake and eat it too, that is, have two Y axes and a slight overlap of the bars? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| overlapping error bars | Charts and Charting in Excel | |||
| Linking Axes Max & Mins to source chart | Charts and Charting in Excel | |||
| Bars in a chart??????? | Excel Worksheet Functions | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| Create a custom chart, two stacked bars/month w/ two axes? | Charts and Charting in Excel | |||
Linear Mode
