Chart : 2 axes stacked bar and line

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how to :

2 axes stacked bar and line graph

i've been trying to figure this out - but it only lets me do a normal bar
and line graph - NOT stacked bar aaaaaaaarrrgh
 
Hi,

Ignore the combination charts offered and create your own.
Start with a stacked bar chart based on all your data. Select the series
you want to plot as a line and right click. On the context menu pick
Chart Type. Select required line type. If it is not automatically placed
on the secondary axis double click the line series and on the Axis tab
change to the secondary axis.

If you meant horizontal bars rather then vertical columns you can still
do the combination but you will need to use xy-scatter instead of line
chart. And obviously you will need to supply the X and Y values.

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

Excel How to create a stacked bar graph 0
How do I create a stacked-bar/Line combination chart? 1
Graph bars are sticking 6
Stacked Bar - 2 Axes 1
Graph Manipulation 2
Bar graph and stacked bar graph on same graph 3
Combination Chart 1
Creating a clustered column chart 1

Back
Top