Date Horizontal Chart Axis

tobermory

New Member
Joined
Jun 4, 2012
Messages
39
Hello there,

I don't think what I'm asking is possible, but I'll ask in hope! Here is a link to the spreadsheet I'm working on: easyupload.io

I've created a line chart with multi-level category labels, the horizonal axis are dates, but when I try to format the axis it doesn't recognise the date format to enable me to use the maximum/minimum parameters. Is this due to be being designed with multi-level category labels?

Essentially, I'm trying to squeeze as many dates as possible into horizontal axis whilst still looking readable!

I welcome any suggestions or alternative chart designs to display the information better.
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,118,308
Messages
5,571,463
Members
412,394
Latest member
divster27
Top