View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Brown John Brown is offline
external usenet poster
 
Posts: 7
Default Simple graph question

Hi, totally new to Excel..
....have two columns...in one is a list of about 60 dates during 2008, in the
other a list of miles walked on the specific dates...and have managed to
produce a bar chart showing miles per walk throughout the year.
How do I easily arrange to:-
1. Show a vertical line on the bar chart on the first of each month.
2. Alternately color the area of the graph for the 12 months, say
red..green..red etc
3. Show the total miliages each month.
4. Show the accumulated miliages.
Thanks, J