Combining Chart Styles

D

Del Cotter

How can I display a data series as a line in an Area Chart in Excel?
Click to expand...

Bring the data series in as an area chart series, right click on the
area series, select "Chart Type" and change the type of the series from
Area to Line (or Scatter).

The secret is that Chart Type is a separate property of each series, not
a fixed property of whole charts. So you can mix and match series almost
any way you like, with a few exceptions.

The Combination Chart type is a bit pointless once you learn how to do
combinations yourself, and I never use it.
 
B

BTomS

Del,
Thanks. For some reason I can't go straight to line. I traied that all day
to day. But based on your reply, I tried changin it to scatter and then
changing that to line and it worked. Appreciate your help.
 

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

Filtered view of Visio Chart 0
Style Gallery View 3
Move Chart with Text 0
Possible to Combine reports to's to a single box? 0
Ways to create a budget chart for money managment 1
Help with area under trendline 0
Embed the same Excel multiple times 0
Convert Error Bars to Series and Colour 1

Top