Forum Discussion

Kostas01's avatar
Kostas01
Copper Contributor
Jun 05, 2024

How to edit axis on a pivot graph

Hello Everyone,

 

I will admit that I have spent a considerable amount of time on the issue that I will describe below with any success.

 

I try to built an pivot graph. On x-axis I have time and dates. When I expand the timeline my x-axis is a mess. Please see the picture below.

 

Ideally, I would like to create a graph with only the dates which I want on the graph and without the time. For example the second graph is exactly what I need. Any idea how to edit my axis?

 

 

 

excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jun 06, 2024

    Kostas01 Pleas save your file, or one similar to your real one, to OneDrive or similar file sharing site and provide the link to access it. Then we don't have to recreate your scenario in order to provide a solution.

Resources