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
PascalKTeam's avatar
PascalKTeam
Iron Contributor
Jan 14, 2020

Hi Jeroenadegraaf 

 

I'm working a lot with combined charts so hopefully, I can help you solve the problem.

Attached file shows 2 possible solutions. 

Option 1: add a vertical line for the current week

Option 2: mark the column with the current week with a different colour

Please play around with the file by changing the values in the yellow marked cells.

 

If this works, you should be able to copy it into your file and change the data source of the chart to your data

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.

     

     

Resources