Forum Discussion
Vertical Line Charts
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!