stacked and clustered column with a line

E

EAF

I have created a stacked and clustered column chart but
now I would like to add a line to that chart. Is that
possible?
 
J

Jon Peltier

Add the data to the chart (copy the range, use Paste Special on the Edit
menu to add it as a new series). Whatever type series it appears as,
select the series, choose Chart Type from the Chart menu, and select the
line type you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
E

EAF

Thanks Jon! :)
-----Original Message-----
Add the data to the chart (copy the range, use Paste Special on the Edit
menu to add it as a new series). Whatever type series it appears as,
select the series, choose Chart Type from the Chart menu, and select the
line type you want.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


.
Click to expand...
 

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

Can Excel produce a clustered and stacked column chart? 2
Stacked Clustered Column? 1
Clustered-Stacked-Column Combo Chart With Lines 2
Cluster Stack Column Line Chart in Windows vs Mac 0
Multiple stacked clustered bars 1
Charting 4
Clusted stacked column chart - "Value (Y) axis crosses betweencategories" greyed out problem 0
How do I combine stacked and clustered chart types? 2

Top