How do I create a combination graph with stackedColumns+lineGraph

C

ChartQuestion

I'm trying to create a custom graph which has both stacked columns bar graph
and also a line graph. I know excel has a combination graph with a bar graph
and a line graph, but there is no option for a stacked bar and a line

Any ideas?
 
B

bj

plot the data you want to be a line as part of the stacked column chart
Select the data set on the chart
got to <chart><Chart type and select <line> and select the details
You wil now have a stacked cart with a line.
 

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

Dynamic graph 0
Dynamic graph issue 2
Overlay line graph points on bar graph 1
Automatic Macro to create 200 graphs 1
Getting the graph style I want 4
Graph Line Width ? 1
Combination Stacked Bar and Line Graph 1
How do I add a total to a clustered bar graph 0

Top