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

Hi, 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.
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 monthly miliages
4. Show the accumulated miliages.
Thanks, J
========