We help IT Professionals succeed at work.

how to get two smaller data sets to use the secondary axis

agwalsh
agwalsh asked
on
I have a chart with 6 data sets - two of them (Oranges and TGs Oranges) of a smaller magnitude than then other 4 data sets. I can get Oranges on the secondary axis but how can I get TGS Oranges on the secondary axis as well. In the attached file I have two charts (the first one is what I want but it excludes TGS oranges). The second one includes all the data but it's not showing TGS as a secondary axis. What am I missing? Thanks you
Chartwith2secondaryaxis.xlsx
Comment
Watch Question

View Solution Only

Saqib Husain, SyedEngineer
BRONZE EXPERT

Commented:

Select the topmost line and send it to the primary axis. Another line will appear. Do the same to it. You will get your result.

agwalsh

Author

Commented:
Chart one or two?
Saqib Husain, SyedEngineer
BRONZE EXPERT

Commented:

Chart 2

Mechanical Engineer
SILVER EXPERT
Most Valuable Expert 2013
Top Expert 2013
Commented:
On the first chart, I added a new series for TGs Oranges, then right clicked it, chose Format Data Series, clicked the column chart icon on the resulting task pane, and specified Secondary y-axis.

On the second chart, I rightclicked the secondary y axis labels, chose Format Axis, clicked the column chart icon on the resulting task pane, and specified a maximum scale value of 3.5. I could then rightclick the series that should have been plotted on the secondary axis, choose Format Data Series, click the column chart icon on the task pane, and specify Secondary y-axis.
Chartwith2secondaryaxis.xlsx
agwalsh

Author

Commented:
Thank you both so much - it's the simple things sometimes!