How do you make a combination chart with 2 axis.

S

smw

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?
 
B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scatter chart with categories on x-Axis 2
change chart primary horizontal axis label or name 1
Possible to Combine reports to's to a single box? 0
One extra x axis item that wont go away - can anyone help? 3
Overlaying 2 Data Series with Different Time (X) Axis 3
Plotting Graph with dynamic table 3
Consolidate my data and plot on a dual axis chart 3
Employee Schedule not plotting properly - chart type / data series not correct 0

Top