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

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

Watch MrExcel Video

Forum statistics

Threads
1,118,850
Messages
5,574,647
Members
412,607
Latest member
caner
Top