COLUMN AND LINE CHARTS IN ONE CHART

I

ian_s_mcd

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.
 
A

Andy Pope

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.

Re: Population pyramid, your welcome.

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

simple chart 0
Line chart with dotted lines rendered poorly in presentation mode 0
Line chart based on 3 columns 0
Chart Lines 2
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Aligning line chart with column chart (4 categories) 0
Line Chart from office 2003.xls not formatted properly in 2007 0
PowerPivot How to chart with contiguous time axis? 0

Top