Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COLUMN AND LINE CHARTS IN ONE CHART
I am trying to create a business-like chart that has columns and lines
together in one chart. I have five data I wish to show on one chart - some in column chart format and some in line chart format. Do anyone know what I mean? And how can I do this? Any kind help would be great. Many thanks to Andy Pope for his help to my problem (how to create a population pyramid) last October. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COLUMN AND LINE CHARTS IN ONE CHART
Hi,
The simplest way is to create a column chart based on all your data. Then select one of the columns that you want to chart as a line. Right click and choose Chart Type. Select the line chart you need. Repeat as required for other data series. Population pyramid, your welcome. Cheers Andy ian_s_mcd wrote: I am trying to create a business-like chart that has columns and lines together in one chart. I have five data I wish to show on one chart - some in column chart format and some in line chart format. Do anyone know what I mean? And how can I do this? Any kind help would be great. Many thanks to Andy Pope for his help to my problem (how to create a population pyramid) last October. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
How to draw an line chart starting at column 1 | Charts and Charting in Excel | |||
Column & Line Charts | Charts and Charting in Excel | |||
Column Chart to Line Chart | New Users to Excel | |||
pivot table multi line chart | Charts and Charting in Excel |