View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Kelvin Kelvin is offline
external usenet poster
 
Posts: 13
Default Chart Won't Display Properly

Would really appreciate some help with this ...

Trying to put the following data into a chart, which shows the the spread of
employees over certain ages:
Age Number
22 3
25 2
26 3
27 11
28 17
29 18
30 15
31 22
32 16
33 21
34 32

- The way I want this to work is to have the ages ascending on the x axis
and the number shown in columns for the y axis.
*But* when I use the auto-chart feature, it puts this into two data series,
one for Age & one for Number, with a load on nonsense on the x & y axes..
Please help!!

Many thanks,

Kelvin