Combination

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

UsGrant_75 - 27 Oct 2006 20:01 GMT

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

Reply to this Message

Andy Pope - 27 Oct 2006 20:04 GMT

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

> 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...
[quoted text clipped - 3 lines]
> switches to right axis?
> Any insight is appreciated

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message