Chart - Pace won't display correctly on Y Axis

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
951
Office Version
  1. 365
Platform
  1. Windows
Hi

I'm trying to set up a new chart with dates on the X axis and pace (m:ss) on the Y axis.

The range is correct for both. The dates are displaying correctly on the X axis but the Y axis only displays 0:00 for all the entries and I don't understand why, as the Edit Series box shows a sample of the pace values in the expected format.

Help would be appreciated!

Thank you.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

goesr

Well-known Member
Joined
Nov 15, 2013
Messages
678
Hello Ironman. Would something like this work below? Hope this helps get you started.
1635975611253.png
 

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
951
Office Version
  1. 365
Platform
  1. Windows
Hi goesr, many thanks for trying to help me.

The Pace axis is in the custom format m:ss and that's where the difficulty lies - my apologies for omitting to state this.
 

goesr

Well-known Member
Joined
Nov 15, 2013
Messages
678
Sorry - I misunderstood m:ss. Have you tried converting m:ss to just seconds (1m:32ss = 92) and then plotting pace in seconds per date?
 

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
951
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

That's a good suggestion goesr but I'd like to avoid a helper column if I can.
 

goesr

Well-known Member
Joined
Nov 15, 2013
Messages
678
We will not be defeated!!! I hope you can understand what I did to get the orange graph. I had to first create a graph using data formatted as General to get the dates and 1, 2, 3, 4, 5, 6. I then had to paste the data formatted as h:mm:ss where the 1, 2, 3, 4, 5, and 6 were. This converted the graph to h:mm:ss and you always have 0 for the h (unless you are VERY slow - but as an "Ironman" that shouldn't be a problem. Hope this helps get you started. See below.
1635983837366.png
 

Ironman

Well-known Member
Joined
Jan 31, 2004
Messages
951
Office Version
  1. 365
Platform
  1. Windows
Hi goesr, many thanks for all the time you've taken on this.

I've followed your suggestion and it worked perfectly, thank you!

The problem I have is Excel doesn't like the size of the range (Jan 2018 to date) so the axis looks great but the data isn't so great :)
 

Attachments

  • Chart 2018-2021.png
    Chart 2018-2021.png
    51.2 KB · Views: 4
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,482
Messages
5,770,351
Members
425,612
Latest member
martinijr

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top