How to create 2 charts on one page

B

Beloved34

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

column charts with set set of data 0
Adding a line to a population bar chart 0
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Using the full width of an Excel chart with two Y-axes 2
Help with Bar-Line Chart..not aligned?? 1
Excel 2007 charts: want to avoid zero values 1
extra info is showing up in my secondary x axis, I can't get rid o 1
Dynamic charts with named range Windows 8.1 0

Top