| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar graph and stacked bar graph on same graph
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bar graph and stacked bar graph on same graph
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Bar graph and stacked bar graph on same graph
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I graph data daily as a line graph across a calendar format | Charts and Charting in Excel | |||
| Cluster stacked graph AND line combo graph? | Charts and Charting in Excel | |||
| Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
| Powerpoint Graph- Shading in between two linear graph lines | Charts and Charting in Excel | |||
| Hyperlinkage of one graph with another graph or Drill down graph | Charts and Charting in Excel | |||
Linear Mode
