Too many PivotChart x-axis label categories

Hi
I have created a pivot table and chart containing electricity uasage data per phase and the neutral current over a 7 or 8 day period.

The data is sorted by date, then hour then minutes (30, 10 or 2 minute intervals depending on the data source).

When the chart is created the date shows up clearly but the hour and minute labels are there for every hour and every minute so there is a black strip of illegible lables. I just need to turn off or only display every other one so it's legible

I've spent too many hours trying to find the remedy on the net but to no avail. Any help would be great, even a "It can't be done" would help.

I've attached a picture if it helps

Chatty

Hi Chatty,

Welcome to the forum! PivotCharts can be tough to work with...and even tougher to format. Could you supply an example workbook, with dummy data, so that other members of the community can play around with it a bit? It's the best way to get an answer quickly. It would be even more helpful if you could include as much info as possible on what your desired outcome might be.

If you create a field that is Date+Time you can control the labelling a little better.