View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Word/Excel Charts x axis to months

Do you have the data set out like this:
NOV 22
DEC 34
JAN 12
......
Now select all the data and make the chart.
It sounds like you just have a column of numbers (promotions)
best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"alison" wrote in message
...
Hi,
I'm trying to format a bar chart which has promotions on the y axis and i
would like the x axis to be months of the year NOV, DEC, JAN 08, FEB 08
and
so forth instead of numbers 0-7 but I dont know how to change this? The
chart
has bars across according to which month(s) the promotion will be
happening
in the next financial year. The chart is currently in word in the document
and connected to data on excel. I'm using microsoft office 2007. anyone
help
plz?