How to create 2 charts on one page

G

Guest

I have created a yearly chart for widgets accomplished in Excel (has 4 data
lines). I would like to add another chart directly below this to show the
turn-time for accomplishing the widgets. It would have the same X-axis values
(months of the year). I tried using a secondary Y axis, and the chart is just
unreadable with this approach. Can this be done. HELP.
 
D

David Biddulph

You haven't told us why it's unreadable, so I doubt that we can help. If
your problem is that the two sets of data are overlapping, and you said you
wanted the second chart *below* the first one, try adjusting the scales on
the 2 Y axes to offset the relevant series appropriately. Format Axis/
scale tab.
 

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

How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Thermometer chart with 2 Y axis? 3
Using the full width of an Excel chart with two Y-axes 2
Help with Bar-Line Chart..not aligned?? 1
Swap Y-Axis numbers 3
Stacked Color Charts 1
Clustered column with secondary y-axis 1
superimposed 3-D stacked area charts 2

Top