Bar graph and stacked bar graph on same graph

B

BRB

This is a strange request.
I know how to do graphs with multiple y-axis, but I've been asked to graph 5
columns of data. The first 3 columns as a bar graph on the left y-axis and
the last 2 columns as a stacked-bar graph on the right y-axis.
Can this be done? If so, how?
Thanks for the help
 
A

akphidelt

I do not think that is possible.

I have seen some crazy graphs where people will make a transparent graph and
place it on top of another graph that gives the effect of one graph.
 
A

akphidelt

haha, that was kind of a guess. Ive never done a transparent graph with a
stacked graph.

But to make a graph transparent you just click on
Format Plot Area
Format Chart Area

Then change Border to None and Area to None
And you can also take off the gridlines. How you get both to come together
accurately I am not entirely 100% sure.
 

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
Scale of Graph Axis 2
Graph Question 6
Graph Autorange 2
Date Format + Graph 2
Stacked Bar graph 5
Draw a horizontal bar and line graph 1
Multiple Data Sets on Same Graph 1

Top