I'm trying to create a simple (or so I thought) line chart so I can track my progress as I get back in to cycling. I ride the same route to and from work and want to see how I'm improving. I have the following data:
-Date
-Time (how long did the ride take me?)
-Average Speed
I'd like to create one chart showing two lines (one for my time from home to work, the other for work to home). It should have the ride time on the Y axis and the dates of my rides on the X axis. I've created plenty of charts before, but this one doesn't want to work. Here's what I have so far:Biking Tracker.xlsx
Then I want to create a similar chart tracking my average speed, using my speed as the Y axis.
I've tried changing the formatting of the source data and tinkering around with the resulting chart settings, but I can't seem to make any progress. Help! Thanks in advance!
Bookmarks