I am creating a line chart based on 3 columns of data -- name, date and
location. Date is to go on the x-axis and location on the y-axis. However,
on the y-axis an amount appears whether than the location name. Is there a
way to get it to show the location name?

Carolyn

In a line chart, the Y axis (the vertical axis) is a value axis. How would
the location be plotted otherwise? I suppose you could use some kind of
code, 1 = Location A, 2 = Location B, etc., plot the numbers, then use some
technique to show the text labels instead:

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

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


"Carolyn" wrote in message
...
I am creating a line chart based on 3 columns of data -- name, date and
location. Date is to go on the x-axis and location on the y-axis.
However,
on the y-axis an amount appears whether than the location name. Is there
a
way to get it to show the location name?

Carolyn

Jon:

Were those your Gantt charts on the web I was viewing? If so, thank you and
many thanks for this response.

Carolyn

"Jon Peltier" wrote:

In a line chart, the Y axis (the vertical axis) is a value axis. How would
the location be plotted otherwise? I suppose you could use some kind of
code, 1 = Location A, 2 = Location B, etc., plot the numbers, then use some
technique to show the text labels instead:

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

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


"Carolyn" wrote in message
...
I am creating a line chart based on 3 columns of data -- name, date and
location. Date is to go on the x-axis and location on the y-axis.
However,
on the y-axis an amount appears whether than the location name. Is there
a
way to get it to show the location name?

Carolyn