ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Simple graph question (https://www.excelbanter.com/excel-discussion-misc-queries/214718-simple-graph-question.html)

John Brown

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




All times are GMT +1. The time now is 10:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com