ExcelBanter - Catagory Axis

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

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

- - Catagory Axis (https://www.excelbanter.com/charts-charting-excel/54127-catagory-axis.html)

I am using a combination chart with dual axis. I am plotting large values on
the right side and percentages on the left side. However my Catagory Axis is
at 0 on the left side and 15,000,000 on the right side. I would like to show
both values aligned at 0. Is this possible?

You have to set the scales of both axes so they coincide. Do this by
double-clicking on one axis, choosing the Scale tab, and setting
appropriate parameters; then repeat for the other axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

tgorham wrote:

I am using a combination chart with dual axis. I am plotting large values on
the right side and percentages on the left side. However my Catagory Axis is
at 0 on the left side and 15,000,000 on the right side. I would like to show
both values aligned at 0. Is this possible?