View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Carol Rutledge Carol Rutledge is offline
external usenet poster
 
Posts: 1
Default data labels in charts

This is a probably one of the simplest questions but I'm just starting to
chart again.

I have entered a category title "year" in cell A1 and entered from 1995 to
2000 from A2 to A7 that I want to appear on the horizontal axis. I have
entered a title in B1(unemployed) and 5 values B2 to B7 directly below. When
I choose a "column" chart my vertical axis appears correctly but the
horizontal axis does not include the years as labels. The labels that appear
are the numbers 1 to 6 instead of 1995 to 2000. How do I make the chart pick
up the data labels from column "A"?

I used to make charts a long time ago and I never remembered this being a
problem.

Thanks anyone.

--
Carol