Bar graph and stacked bar graph on same graph

[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

 

[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.

 

[BRB]

Cool. I would settle for that. How do I do that?

Thanks,

 

[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.