ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Dual Vertical Y-Axis (https://www.excelbanter.com/charts-charting-excel/141401-dual-vertical-y-axis.html)

gvm

Dual Vertical Y-Axis
 
I have read the post on the above subject but need I clarification please. I
use Excel 2003 and want to chart two line graphs with appropriate scales/axes
on both left and right sides of the chart. How do I do that please? TIA
..... Greg

gvm

Dual Vertical Y-Axis
 
Found it! ... under custom chart types ... Greg

"gvm" wrote:

I have read the post on the above subject but need I clarification please. I
use Excel 2003 and want to chart two line graphs with appropriate scales/axes
on both left and right sides of the chart. How do I do that please? TIA
.... Greg


Andy Pope

Dual Vertical Y-Axis
 
Hi,

Although custom types will work it is normally easier to do it yourself.

Create a line chart on both sets of data.
Double-click the series you wish to place on the secondary axis. On the
format dialog Scale tab select secondary axis.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"gvm" wrote in message
...
Found it! ... under custom chart types ... Greg

"gvm" wrote:

I have read the post on the above subject but need I clarification
please. I
use Excel 2003 and want to chart two line graphs with appropriate
scales/axes
on both left and right sides of the chart. How do I do that please? TIA
.... Greg




All times are GMT +1. The time now is 07:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com