View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
AKphidelt AKphidelt is offline
external usenet poster
 
Posts: 461
Default Bar graph and stacked bar graph on same graph

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.

"BRB" wrote:

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

Thanks,

"akphidelt" wrote:

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" wrote:

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