Forum Discussion

Jeroenadegraaf's avatar
Jeroenadegraaf
Copper Contributor
Jan 10, 2020

Adding a timeline (current week) to a pivot-graph

Hello,   I have made a PivotGraph with week-numbers on the x-axis. I want to plot the current week in the graph with a vertical line. My approach was a combined graph with lines for my data and a s...
excel
office 365
Jeroenadegraaf's avatar
Jeroenadegraaf
Copper Contributor
Jan 15, 2020

PascalKTeam 

 

Thank you for your reply. My problem occurs when I'm using a PivotGraph based on a PivotTable.

Do you have a sollution for that as well?

 

Regards,

 

JeroenAdeGraaf

PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 15, 2020

Hi Jeroenadegraaf 

 

Yes sure. In attached document, there's a pivot chart on the right which marks the current week (from cell J2) in a different colour. Just change value in J2, refresh the pivot table and you will see.

 

 

    • PascalKTeam's avatar
      PascalKTeam
      Iron Contributor
      Jan 15, 2020

      Hi Jeroenadegraaf 

       

      You have added some additional rows and columns without updating the formulas, this is why it didn't work. Now it works, see attached file

      • Jeroenadegraaf's avatar
        Jeroenadegraaf
        Copper Contributor
        Jan 15, 2020

        PascalKTeam 

         

        But can you combine lines for the labels with a column for the current week? Or a vertical line for the current week? Because I have about 90 labels in my graph and columns don't give good visual result.

        The 90 labels are also the reason I need the slicer.

         

        Jeroen

Resources