ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do you make a combination chart with 2 axis. (https://www.excelbanter.com/charts-charting-excel/48815-how-do-you-make-combination-chart-2-axis.html)

smw

How do you make a combination chart with 2 axis.
 
I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do I
put both on same chart?

Barb Reinhardt

Plot them both like they would be using the same Y axis.

Select the one that you want on the secondary axis and format the data
series. On the AXIS tab, you can select a secondary axis.

"smw" wrote in message
...
I'm tring to plot 2 kinds of data. 1 is a % and the 2 is a quanity. How do
I
put both on same chart?





All times are GMT +1. The time now is 02:51 AM.

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