Hi,
You can place a series on the secondary axis by double clicking the
series and picking Secondary from the Axis tab.
If you have 2 series you will need both on the primary axis first in
order to set the events series to the secondary.
Cheers
Andy
UsGrant_75 wrote:
I have a chart that has Percent on Right Vert Axis and Number of events on
Left Vert Axis...I want to change it so Percent is on left vertical axis...
I tried starting from scratch...only Percent dat so left axis is
percent...then add data row below percent data....and percent vert axis
switches to right axis?
Any insight is appreciated
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info