How to create 2 charts on one page
 

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.

How to create 2 charts on one page
 

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.
--
David Biddulph

"Beloved34" wrote in message
...
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.

How to create 2 charts on one page
 

You mean a panel chart:

http://peltiertech.com/Excel/Charts/StackedCharts.html
http://peltiertech.com/Excel/ChartsH...venScales.html
http://peltiertech.com/Excel/Comment...DayOfYear.html
http://peltiertech.com/Excel/ChartsH...nelChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Beloved34" wrote in message
...
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.