If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Overlay charts in 2007
Is it possible to overlay a column chart with a line chart in Excel 2007?
It looks as if the horizontal axis has 2 groups of labels and the charts are using the same vertical axis labels. thank you for your time, Christy |
#2
|
|||
|
|||
Overlay charts in 2007
Yes.
Please look at:- http://www.pierrefondes.com/ - item number 69 towards the top of my home page where there is a worked example. Please hit yes if my comments have helped. Thanks. "Christyr" wrote: Is it possible to overlay a column chart with a line chart in Excel 2007? It looks as if the horizontal axis has 2 groups of labels and the charts are using the same vertical axis labels. thank you for your time, Christy |
#3
|
|||
|
|||
Overlay charts in 2007
Make a column chart with all the data, then right click on one series,
choose [Change] Chart Type, and select a line chart type for the selected series. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 2/22/2010 1:50 PM, Christyr wrote: Is it possible to overlay a column chart with a line chart in Excel 2007? It looks as if the horizontal axis has 2 groups of labels and the charts are using the same vertical axis labels. thank you for your time, Christy |
Thread Tools | |
Display Modes | |
|
|