Hi all,
Using Excel 2007
I found a nice tutorial on Jon Peltier's blog for a panel chart http://peltiertech.com/WordPress/chart-busters-compare-employee-sales/
The instructions appear to be for Excel 2003 or earlier
I am trying to make it work in Excel 2007 and stumbling a bit.
Before adding the helper chart I checked that the first schart isusing the primary axis - it is.
I selecte the table for the helder data and attempted to paste special
but when I'm done the original data is plotted on the secondary axis and the helper data is plotted on the primary axis.
When I click on either data series, the Primary and Secondary axis is ghosted, so I cannot flip them.
Any ideas what I'm doing wrong?
Thanks
Winston
Using Excel 2007
I found a nice tutorial on Jon Peltier's blog for a panel chart http://peltiertech.com/WordPress/chart-busters-compare-employee-sales/
The instructions appear to be for Excel 2003 or earlier
I am trying to make it work in Excel 2007 and stumbling a bit.
Before adding the helper chart I checked that the first schart isusing the primary axis - it is.
I selecte the table for the helder data and attempted to paste special
but when I'm done the original data is plotted on the secondary axis and the helper data is plotted on the primary axis.
When I click on either data series, the Primary and Secondary axis is ghosted, so I cannot flip them.
Any ideas what I'm doing wrong?
Thanks
Winston