SOLVED
Home

Excel Combo Graph

%3CLINGO-SUB%20id%3D%22lingo-sub-676280%22%20slang%3D%22en-US%22%3EExcel%20Combo%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-676280%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20create%20a%20combo%20graph%20with%20a%20bar%20graph%20for%20one%20series%20and%20a%20line%20graph%20for%20another%20stacked%20on%20top.%20I%20want%20the%20first%20series%20(blue)%20to%20be%20horizontally%20graphed%20like%20so%3A%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20716px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117390i82C5A38FDF2F1EC2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22pic%201.png%22%20title%3D%22pic%201.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ebut%20I%20want%20the%20second%20series%20(orange)%20to%20be%20a%20vertical%20line%20or%20even%20scattered%20points.%20Every%20time%20I%20try%20to%20convert%20one%20series%20to%20a%20line%20graph%2C%20the%20axis%20switches%3A%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20718px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117392i84C2276D81EA4850%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22pic%202.png%22%20title%3D%22pic%202.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAnd%20when%20I%20try%20to%20switch%20it%20back%20I%20get%20something%20like%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20707px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117393iEACCD21BF0BE2B75%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22pic%203.png%22%20title%3D%22pic%203.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-676280%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-676357%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Combo%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-676357%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356131%22%20target%3D%22_blank%22%3E%40Torifox43%3C%2FA%3E%26nbsp%3B%2C%20if%20you%20mean%20something%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20623px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117401iA8D6C923FED4F1C6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E1)%20Change%20orange%20series%20to%20Scatter%20type%3C%2FP%3E%0A%3CP%3E2)%20Add%20helper%20column%20to%20your%20data%20(before%20names%20here)%3C%2FP%3E%0A%3CP%3E3)%20Right%20click%20on%20chart%2C%20Select%20Data%2C%20Edit%20series%20B%20(scatter)%2C%20select%20B%20column%20as%20X%20and%20helper%20column%20as%20Y%3C%2FP%3E%0A%3CP%3E4)%20disable%20secondary%20vertical%20axis%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-676394%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Combo%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-676394%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BYes%2C%20that's%20exactly%20what%20I%20want%2C%20but%20I'm%20having%20trouble%20following.%20I%20added%20the%20helper%20column%2C%20but%20am%20I%20supposed%20to%20include%20it%20when%20inserting%20the%20graph%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20237px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117403iD20D4C37B888D9BC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Capture2.PNG%22%20title%3D%22Capture2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EEither%20way%2C%20if%20I%20include%20it%20or%20don't%2C%20I'm%20not%20getting%20an%20option%20to%20select%20any%20x%20or%20y%20values%2C%20it%20just%20shows%20me%20this%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20322px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117402i5057AA3573FFA3C9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-676471%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Combo%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-676471%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356131%22%20target%3D%22_blank%22%3E%40Torifox43%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20you%20convert%20orange%20bar%20to%20scatter%20and%20Select%20Data%20for%20the%20resulting%20chart%20it%20looks%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20439px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117408i5187A5F21B2AFF2C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHere%20click%20on%20Edit%20Scatter%20series%20(B)%2C%20you'll%20see%20something%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20335px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117409i21FAD14DB20E25CB%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EHere%20change%20X%20and%20Y%20values%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20330px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117411i991A3FF812DF455E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EAll%20these%20steps%20are%20in%20the%20file%20I%20attached%20to%20previous%20post.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-677984%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Combo%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-677984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much!%20The%20only%20problem%20I'm%20having%20now%20is%20that%20the%20scatterplot%20isn't%20matching%20up%20perfectly%20with%20the%20bar%20graph.%20Is%20there%20a%20way%20to%20correct%20this%3F%20I%20tried%20doing%20it%20with%20the%20bounds-%20but%20this%20is%20as%20close%20as%20I%20could%20get%20it%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20629px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117464i20840D0021D6ACE8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-678072%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Combo%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-678072%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F356131%22%20target%3D%22_blank%22%3E%40Torifox43%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20try%20as%20following%20-%20enable%20secondary%20vertical%20axis%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20558px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117472i08DE203610248FE2%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eclick%20on%20it%20to%20format%20and%20here%20change%20default%20minimum%20value%20on%200.5%20(instead%20of%20zero).%20Major%20unit%20shall%20be%201%20by%20default%20(otherwise%20change%20on%201)%2C%20maximum%20will%20go%20on%206.5%20in%20my%20case%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20297px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117470i5F7635D75C73FCAD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ENow%20disable%20secondary%20vertical%20axis%2C%20finally%20it'll%20be%20like%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20356px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F117471i1F238AAEC59B1EB5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Torifox43
Occasional Contributor

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: pic 1.png

 

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: pic 2.png

And when I try to switch it back I get something like this: 

pic 3.png

 

5 Replies

@Torifox43 , if you mean something like this

image.png

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

@Sergei Baklan 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?

 

Capture2.PNG

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: 

 

Capture.PNG

 

Solution

@Torifox43 ,

 

After you convert orange bar to scatter and Select Data for the resulting chart it looks like

image.png

Here click on Edit Scatter series (B), you'll see something like

image.png

Here change X and Y values:

image.png

All these steps are in the file I attached to previous post.

@Sergei Baklan Thank you so much! The only problem I'm having now is that the scatterplot isn't matching up perfectly with the bar graph. Is there a way to correct this? I tried doing it with the bounds- but this is as close as I could get it 

 

Capture.PNG

@Torifox43 

 

Please try as following - enable secondary vertical axis

image.png

click on it to format and here change default minimum value on 0.5 (instead of zero). Major unit shall be 1 by default (otherwise change on 1), maximum will go on 6.5 in my case

image.png

Now disable secondary vertical axis, finally it'll be like

image.png

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies