Out fishing with Annie on his lap, a cigar in one hand and a ginger ale in the other, watching the sunset.
Join Date: Mar 2006
Location: South Florida
Posts: 16,056
Bikes: Techna Wheelchair and a Sun EZ 3 Recumbent Trike
Mentioned: 3 Post(s)
Tagged: 0 Thread(s)
Quoted: 9 Post(s)
Likes: 0
Originally Posted by keith_b00ne
The way that you have set Excel up to handle the data seems overly complicated for what you are trying to achieve. A simple form that you enter ride date, miles, and average speed is sufficient for excel to make a graph and summarize by month. Putting in every day of the year seems pointless and difficult to see the data.
See the version im the ExcelV2.0 thread...It's a bit larger sizewise, but graphs on a monthly basis and the macros work.
All you have to do is enter the ride data for the date and it will update to the appropriate graph.
__________________
. “He who fights with monsters might take care lest he thereby become a monster. And if you gaze for long into an abyss, the abyss gazes also into you.”- Fredrick Nietzsche
"We can judge the heart of a man by his treatment of animals." - Immanuel Kant