Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to create 0 to 0 value charts | Charts and Charting in Excel | |||
how do i create 4 pie charts | Charts and Charting in Excel | |||
How do I put multiple pie charts on one page? | Charts and Charting in Excel | |||
two charts on one chart page | Charts and Charting in Excel | |||
1 of 4 charts on page won't print | Charts and Charting in Excel |