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. |
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 |
All times are GMT +1. The time now is 04:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com