Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Cluster charts and the secondary y-axis
I'm trying to create a cluster chart with two series' of data but with a
secondary y-axis. Upon clicking on secondary axis (Format Data Series / Axis / Plot on secondary axis) it stacks each cluster, meaning each data pair. I want them to stay side by side, just as they appear when there is only one axis (ie. no overlap). Once the secondary axis is clicked off, manipulating the overlap has no effect. I can't seem to separate the pairs. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Cluster charts and the secondary y-axis
You need to add some blank dummy series to maintain proper positioning of
the series. http://peltiertech.com/Excel/Charts/...OnTwoAxes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "8472" wrote in message ... I'm trying to create a cluster chart with two series' of data but with a secondary y-axis. Upon clicking on secondary axis (Format Data Series / Axis / Plot on secondary axis) it stacks each cluster, meaning each data pair. I want them to stay side by side, just as they appear when there is only one axis (ie. no overlap). Once the secondary axis is clicked off, manipulating the overlap has no effect. I can't seem to separate the pairs. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|