Forum Discussion
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 semi transparent column on the current week.
This seemed to work, but as soon as I use the slicer to select data, the lines of the graph are replaced by columns.
Any suggestions to solve this?
Jeroenadegraaf
11 Replies
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
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
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.
