If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Charting on Primary & Secondary Axis - Zero Point Does Not Align
Hi
I am charting profit margins ranging from - 6 to 8+ on the primary axis (line graph) and net worth of the companies (columns) on the secondary axis. How do I align the zero point (0%) on the primary and 0$ on the secondary axis? Right now, the chart that I have shows the bottom of the columns on the same horizontal plane as the -6% profit margin point on the chart. Thanks in advance for your help. |
#2
|
|||
|
|||
Charting on Primary & Secondary Axis - Zero Point Does Not Align
Hello,
Jon Peltier has instructions showing how to align the zeros on a primary and secondary axis on his site. Please refer to the link below. http://peltiertech.com/Excel/Charts/AlignXon2Ys.html -- John Mansfield http://www.cellmatrix.net "Al Charbonneau" wrote: Hi I am charting profit margins ranging from - 6 to 8+ on the primary axis (line graph) and net worth of the companies (columns) on the secondary axis. How do I align the zero point (0%) on the primary and 0$ on the secondary axis? Right now, the chart that I have shows the bottom of the columns on the same horizontal plane as the -6% profit margin point on the chart. Thanks in advance for your help. |
Thread Tools | |
Display Modes | |
|
|