Scaling within a chart

G

Guest

I have 3 series of data; 1. A total figure (1500-2500) and two series of
percentages (0-100%).

I would like to show them all on the one chart but the scale sits far too
hight to see the percentages and they just look like straight lines. Is it
possible to have two different types of figures that are numerically far
apart scaled down to assist in reading? Any help would be appreciated.
 
D

David Biddulph

Yes, right-click one of the series, Format Data Series/ Axis / and select
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

Scaling of data in Line chart 6
stacked bar chart with percentages 2
Chart Type 2
Stacking data from within a series within a bar chart 1
Column chart with 3 orders of magnitude 2
Chart creation 2
Pie Chart with 3 data series? 4
How to show a cumulative value over time in a pivot chart. 1

Top