Home

Vertical Line Charts

%3CLINGO-SUB%20id%3D%22lingo-sub-332000%22%20slang%3D%22en-US%22%3EVertical%20Line%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332000%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Everyone!%26nbsp%3B%20I've%20been%20working%20on%20this%20problem%20for%20a%20few%20days%20now%20and%20I%20can't%20get%20it%20going.%26nbsp%3B%20I%20need%20to%20create%20a%20vertical%20line%20chart.%26nbsp%3B%20It's%20easier%20to%20show%20in%20photos.%26nbsp%3B%20I%20have%20this....%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F72171i767DAB4A3522EEB8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Line%20Graph%20(Horiz).png%22%20title%3D%22Line%20Graph%20(Horiz).png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20it%20to%20be%20rendered%20like%20this%20(created%20by%20rotating%20previous%20photo).....%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20219px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F72172i8B593BF3A32CC99E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22Line%20Graph%20Vert.png%22%20title%3D%22Line%20Graph%20Vert.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EWhat%20would%20become%20the%20Y-axis%20(the%20categories)%20are%20text.%26nbsp%3B%20I've%20tried%20just%20flipping%20the%20axes%20in%20the%20%22Select%20Data%22%20dialog%20box%2C%20but%20I%20think%20the%20problem%20is%20that%20Excel%20keeps%20wanting%20anything%20on%20the%20Y-axis%20to%20be%20numerical%20rather%20than%20textual%3B%20it%20then%20messes%20up%20the%20values%20of%20my%20data%20across%20the%20X-axis%20when%20I%20try%20just%20flipping%20the%20two.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyone%20have%20any%20ideas%3F%26nbsp%3B%20I%20am%20not%20a%20coder%3B%20I%20can't%20write%20VBA.%26nbsp%3B%20I'd%20be%20willing%20to%20learn%2C%20but%20I'm%20in%20the%20middle%20of%20thesis%20writing%20so%20that%20would%20be%20difficult%20to%20add%20at%20the%20moment.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-Mike%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-332000%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eline%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eline%20charts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-333484%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20Line%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333484%22%20slang%3D%22en-US%22%3EYou're%20welcome!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-333033%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20Line%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-333033%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20does%20seem%20to%20work.%26nbsp%3B%20So%20far%20it's%20created%20issues%20just%20with%20trying%20to%20get%20the%20legend%20to%20format.%26nbsp%3B%20I'll%20keep%20it%20in%20mind.%26nbsp%3B%20Still%20wish%20Excel%20could%20just%20present%20the%20chart%20the%20way%20I'd%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332434%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20Line%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332434%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20style%3D%22background-color%3A%20%23ffffff%3B%22%3EYou%20could%20try%3A%3CBR%20%2F%3E-%20Create%20the%20chart%20as%20Excel%20defaults%20to%3CBR%20%2F%3E-%20Select%20the%20cells%20behind%20the%20chart%20and%20choose%20(using%20the%20drop-down%20arrow%20next%20to%20the%20copy%20button%20on%20the%20home%20tab)%3A%20Copy%20Picture%3CBR%20%2F%3E-%20Choose%20the%20option%20you%20want%3CBR%20%2F%3E-%20Click%20where%20you%20want%20the%20transposed%20pifture%20to%20be%20and%20click%20Paste%3CBR%20%2F%3E-%20Click%20in%20the%20formula%20bar%2C%20type%20the%20equal%20sign%20and%20-again-%20select%20the%20cells%20underneath%20the%20original%20chart%20and%20press%20enter%3CBR%20%2F%3E-%20Now%20rotate%20the%20picture%20(not%20the%20chart)%3CBR%20%2F%3E-%20Try%20changing%20anyhting%20in%20the%20chart%20or%20its%20data%20and%20see%20the%20picture%20update%20itself%3C%2FFONT%3E.%3C%2FP%3E%0A%3CP%3ESee%20attached%20example%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332402%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20Line%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332402%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20looked%20at%20that%2C%20and%20I%20can%20make%20it%20work%20need%20be.%26nbsp%3B%20I%20am%20aware%20that%20this%20is%20an%20unusual%20presentation.%26nbsp%3B%20I%20am%20an%20archaeologist%2C%20and%20this%20is%20showing%20counts%20per%20excavation%20level%3B%20the%20presentation%20makes%20sense%20because%20I%20can%20show%20data%20points%20as%20each%20level%20gets%20deeper.%26nbsp%3B%20The%20lines%20are%20easier%20to%20see%20than%20the%20bars%2C%20mainly%20because%20I%20have%20several%20different%20material%20types%20which%20are%20quantified%20and%20presented%20simultaneously.%26nbsp%3B%20I%20would%20love%20the%20horizontal%20bar%20charts%20if%20I%20could%20add%20a%20line%20from%20data%20point%20to%20data%20point%20(rather%20than%20a%20a%20trend%20line).%26nbsp%3B%20However%2C%20I%20cannot%20find%20a%20way%20to%20add%20that%20either.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20realized%20I%20can%20create%20a%20workaround%20this%20morning%20where%20I%20reorient%20the%20text%20for%20my%20desired%20outcome%2C%20convert%20the%20chart%20to%20a%20graphic%2C%20then%20rotate%20the%20graphic%20itself%20and%20add%20an%20external%20title.%26nbsp%3B%20I'd%20prefer%20to%20have%20a%20way%20for%20Excel%20to%20create%20the%20chart%20I%20need.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332390%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20Line%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332390%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20tried%20that%20approach.%26nbsp%3B%20Unfortunately%20it%20doesn't%20work%20for%20me%20since%20my%20Y-axis%20is%20categorical%2C%20not%20numeric.%26nbsp%3B%20That's%20a%20workaround%20that%20only%20functions%20in%20the%20example%20because%20of%20the%20numerical%20nature%20of%20the%20categories.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332371%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20Line%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332371%22%20slang%3D%22en-US%22%3EThat%20is%20a%20rather%20unusual%20way%20to%20present%20data.%20Have%20you%20considered%20a%20horizontal%20bar%20chart%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-332024%22%20slang%3D%22en-US%22%3ERe%3A%20Vertical%20Line%20Charts%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-332024%22%20slang%3D%22en-US%22%3E%3CP%3EA%20quick%20Google%20for%20'excel%20vertical%20line%20chart'%20and%20I%20found%20this%20which%20might%20work%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.goodly.co.in%2Fvertical-line-chart-in-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.goodly.co.in%2Fvertical-line-chart-in-excel%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
cookma423
Occasional Contributor

Hey Everyone!  I've been working on this problem for a few days now and I can't get it going.  I need to create a vertical line chart.  It's easier to show in photos.  I have this....

Line Graph (Horiz).png

 

I want it to be rendered like this (created by rotating previous photo).....

Line Graph Vert.png

What would become the Y-axis (the categories) are text.  I've tried just flipping the axes in the "Select Data" dialog box, but I think the problem is that Excel keeps wanting anything on the Y-axis to be numerical rather than textual; it then messes up the values of my data across the X-axis when I try just flipping the two.

 

Anyone have any ideas?  I am not a coder; I can't write VBA.  I'd be willing to learn, but I'm in the middle of thesis writing so that would be difficult to add at the moment.  

 

Thanks in advance!  

 

-Mike

7 Replies

A quick Google for 'excel vertical line chart' and I found this which might work - https://www.goodly.co.in/vertical-line-chart-in-excel/

That is a rather unusual way to present data. Have you considered a horizontal bar chart?

I've tried that approach.  Unfortunately it doesn't work for me since my Y-axis is categorical, not numeric.  That's a workaround that only functions in the example because of the numerical nature of the categories.

I have looked at that, and I can make it work need be.  I am aware that this is an unusual presentation.  I am an archaeologist, and this is showing counts per excavation level; the presentation makes sense because I can show data points as each level gets deeper.  The lines are easier to see than the bars, mainly because I have several different material types which are quantified and presented simultaneously.  I would love the horizontal bar charts if I could add a line from data point to data point (rather than a a trend line).  However, I cannot find a way to add that either.  

 

I realized I can create a workaround this morning where I reorient the text for my desired outcome, convert the chart to a graphic, then rotate the graphic itself and add an external title.  I'd prefer to have a way for Excel to create the chart I need.  

You could try:
- Create the chart as Excel defaults to
- Select the cells behind the chart and choose (using the drop-down arrow next to the copy button on the home tab): Copy Picture
- Choose the option you want
- Click where you want the transposed pifture to be and click Paste
- Click in the formula bar, type the equal sign and -again- select the cells underneath the original chart and press enter
- Now rotate the picture (not the chart)
- Try changing anyhting in the chart or its data and see the picture update itself
.

See attached example

That does seem to work.  So far it's created issues just with trying to get the legend to format.  I'll keep it in mind.  Still wish Excel could just present the chart the way I'd like.

 

Thanks for the help!

You're welcome!
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies