How to create vertical line charts
 

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

How to create vertical line charts
 

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/
_______

"Henrik" wrote in message
...
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

How to create vertical line charts
 

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

Henrik

"Jon Peltier" wrote:

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/
_______

"Henrik" wrote in message
...
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

How to create vertical line charts
 

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/
_______

"Henrik" wrote in message
...
Thanks. If the XY Chart Labeler dynamic, i.e. does it update if labels are
changed?

Henrik

"Jon Peltier" wrote:

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/
_______

"Henrik" wrote in message
...
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

How to create vertical line charts
 

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/
_______

"Jon Peltier" wrote in message
...
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/
_______

"Henrik" wrote in message
...
Thanks. If the XY Chart Labeler dynamic, i.e. does it update if labels
are
changed?

Henrik

"Jon Peltier" wrote:

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/
_______

"Henrik" wrote in message
...
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