Forum Discussion
Excel Combo Graph
I'm trying to create a combo graph with a bar graph for one series and a line graph for another stacked on top. I want the first series (blue) to be horizontally graphed like so:
but I want the second series (orange) to be a vertical line or even scattered points. Every time I try to convert one series to a line graph, the axis switches:
And when I try to switch it back I get something like this:
After you convert orange bar to scatter and Select Data for the resulting chart it looks like
Here click on Edit Scatter series (B), you'll see something like
Here change X and Y values:
All these steps are in the file I attached to previous post.
5 Replies
Torifox43 , if you mean something like this
1) Change orange series to Scatter type
2) Add helper column to your data (before names here)
3) Right click on chart, Select Data, Edit series B (scatter), select B column as X and helper column as Y
4) disable secondary vertical axis
SergeiBaklan Yes, that's exactly what I want, but I'm having trouble following. I added the helper column, but am I supposed to include it when inserting the graph?
Either way, if I include it or don't, I'm not getting an option to select any x or y values, it just shows me this:
After you convert orange bar to scatter and Select Data for the resulting chart it looks like
Here click on Edit Scatter series (B), you'll see something like
Here change X and Y values:
All these steps are in the file I attached to previous post.
