How to create vertical line charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Thanks. If the XY Chart Labeler dynamic, i.e. does it update if labels are
changed?

Henrik
 
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/
_______
 
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/
_______
 
Back
Top