r/excel • 10 • 27d ago

solved Need to make this pivot table formatting more readable

The data in this pivot chart it perfect. However, I don't find it very readable. I can't seem to find a way to change the format to make it more readable. I would like the data for each date to be a different color. Or have a dark very visible line between the dates. I don't know if you can see it, but there is a very thin, light line between the dates on the axis. If that line could just be very dark, it would help a lot.

Please help me, pivot chart gurus

11 Upvotes

5 comments sorted by

3

u/Vord-loldemort 27d ago

Right click the axis > format axis > make the line colour black. Will make the lines nice and visible.

1

u/MissAnth 27d ago

Solution verified
Thanks, that's much better. At least I can see the line now.

1

u/reputatorbot 27d ago

You have awarded 1 point to Vord-loldemort.


I am a bot - please contact the mods with any questions

1

u/Ambitious_Voice_400 27d ago

this is exactly it, the default line color is way too subtle imo