How to create vertical line charts

[Guest]

I'd like to create a vertical line chart, i.e. a normal line chart 'turned 90
degrees'. How can that be done?

(I know you can trick Excel by using a line scatter chart and swapping x-
and y-axis data but I don't see how I automatically can get labels on the
chart.)

Thanks in advance
Henrik

 

[Jon Peltier]

Here's one way:

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Guest]

Thanks. If the XY Chart Labeler dynamic, i.e. does it update if labels are
changed?

Henrik

 

[Jon Peltier]

It's sort of dynamic. If the cell for point 4 is changed, then point 4's
label changes. If you insert a point between 3 and 4, the new point becomes
point 4 and takes on point 4's label, and at the end of the series, one
point loses its label. This isn't the Chart Labeler's fault, it's the way
Excel handles data labels and especially links in data labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Jon Peltier]

I should point out that with the links in the data labels, they will stay
linked to the appropriate cells even if the workbook is sent to someone who
does not have the labeler installed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______