ExcelBanter - Combination

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Combination (https://www.excelbanter.com/charts-charting-excel/116494-combination.html)

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

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