ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   2 scales in 1 chart (https://www.excelbanter.com/charts-charting-excel/110960-2-scales-1-chart.html)

Sirritys

2 scales in 1 chart
 
Hi,

I'm using xl'97 and I'm trying to chart 2 different tables to 1 chart.
To do this I would need XL to display 1 scale on left and another one
on right sided of the chart and then chart both tables to 1 chart.

Is this possible ?

Thanks for help,
Sirritys


Tushar Mehta

2 scales in 1 chart
 
Plot both series on the chart. Then, double-click the series you want on
the secondary (right) axis, and in the resulting dialog box, from the Axis
tab, select 'Secondary'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article .com,
says...
Hi,

I'm using xl'97 and I'm trying to chart 2 different tables to 1 chart.
To do this I would need XL to display 1 scale on left and another one
on right sided of the chart and then chart both tables to 1 chart.

Is this possible ?

Thanks for help,
Sirritys



Sirritys

2 scales in 1 chart
 
Well, that wasn't so hard =)

Thanks a lot =)


Tushar Mehta

2 scales in 1 chart
 
In article .com,
says...
Well, that wasn't so hard =)

Thanks a lot =)


You are welcome. :)
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions


All times are GMT +1. The time now is 08:02 PM.

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