software

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

Here's one way:

peltiertech.com/Excel/Charts/Y_CategoryAxis.html

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

quot;Henrikquot; gt; wrote in message
...
gt; I'd like to create a vertical line chart, i.e. a normal line chart 'turned
gt; 90
gt; degrees'. How can that be done?
gt;
gt; (I know you can trick Excel by using a line scatter chart and swapping x-
gt; and y-axis data but I don't see how I automatically can get labels on the
gt; chart.)
gt;
gt; Thanks in advance
gt; Henrik
Thanks. If the XY Chart Labeler dynamic, i.e. does it update if labels are
changed?

Henrik

quot;Jon Peltierquot; wrote:

gt; Here's one way:
gt;
gt; peltiertech.com/Excel/Charts/Y_CategoryAxis.html
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Henrikquot; gt; wrote in message
gt; ...
gt; gt; I'd like to create a vertical line chart, i.e. a normal line chart 'turned
gt; gt; 90
gt; gt; degrees'. How can that be done?
gt; gt;
gt; gt; (I know you can trick Excel by using a line scatter chart and swapping x-
gt; gt; and y-axis data but I don't see how I automatically can get labels on the
gt; gt; chart.)
gt; gt;
gt; gt; Thanks in advance
gt; gt; Henrik
gt;
gt;
gt;

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
PeltierTech.com/
_______

quot;Henrikquot; gt; wrote in message
...
gt; Thanks. If the XY Chart Labeler dynamic, i.e. does it update if labels are
gt; changed?
gt;
gt; Henrik
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; Here's one way:
gt;gt;
gt;gt; peltiertech.com/Excel/Charts/Y_CategoryAxis.html
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;Henrikquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; I'd like to create a vertical line chart, i.e. a normal line chart
gt;gt; gt; 'turned
gt;gt; gt; 90
gt;gt; gt; degrees'. How can that be done?
gt;gt; gt;
gt;gt; gt; (I know you can trick Excel by using a line scatter chart and swapping
gt;gt; gt; x-
gt;gt; gt; and y-axis data but I don't see how I automatically can get labels on
gt;gt; gt; the
gt;gt; gt; chart.)
gt;gt; gt;
gt;gt; gt; Thanks in advance
gt;gt; gt; Henrik
gt;gt;
gt;gt;
gt;gt;
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
PeltierTech.com/
_______

quot;Jon Peltierquot; gt; wrote in message
...
gt; It's sort of dynamic. If the cell for point 4 is changed, then point 4's
gt; label changes. If you insert a point between 3 and 4, the new point
gt; becomes point 4 and takes on point 4's label, and at the end of the
gt; series, one point loses its label. This isn't the Chart Labeler's fault,
gt; it's the way Excel handles data labels and especially links in data
gt; labels.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;Henrikquot; gt; wrote in message
gt; ...
gt;gt; Thanks. If the XY Chart Labeler dynamic, i.e. does it update if labels
gt;gt; are
gt;gt; changed?
gt;gt;
gt;gt; Henrik
gt;gt;
gt;gt; quot;Jon Peltierquot; wrote:
gt;gt;
gt;gt;gt; Here's one way:
gt;gt;gt;
gt;gt;gt; peltiertech.com/Excel/Charts/Y_CategoryAxis.html
gt;gt;gt;
gt;gt;gt; - Jon
gt;gt;gt; -------
gt;gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt;gt; Peltier Technical Services
gt;gt;gt; Tutorials and Custom Solutions
gt;gt;gt; PeltierTech.com/
gt;gt;gt; _______
gt;gt;gt;
gt;gt;gt; quot;Henrikquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt; gt; I'd like to create a vertical line chart, i.e. a normal line chart
gt;gt;gt; gt; 'turned
gt;gt;gt; gt; 90
gt;gt;gt; gt; degrees'. How can that be done?
gt;gt;gt; gt;
gt;gt;gt; gt; (I know you can trick Excel by using a line scatter chart and swapping
gt;gt;gt; gt; x-
gt;gt;gt; gt; and y-axis data but I don't see how I automatically can get labels on
gt;gt;gt; gt; the
gt;gt;gt; gt; chart.)
gt;gt;gt; gt;
gt;gt;gt; gt; Thanks in advance
gt;gt;gt; gt; Henrik
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;
gt;