Y-axis labels

[Carolyn]

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 Peltier]

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

 

[Carolyn]

Jon:

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

Carolyn