Jan 10 2020 05:04 AM
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
Jan 14 2020 04:44 AM
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
Jan 14 2020 11:25 PM
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
Jan 14 2020 11:35 PM
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.
Jan 15 2020 12:29 AM
Can you take a look at the attached file and the way it responces when the slicer is used?
Jeroen
Jan 15 2020 12:35 AM
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
Jan 15 2020 12:47 AM
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
Jan 15 2020 12:49 AM
Jan 15 2020 02:10 AM
Jan 15 2020 02:17 AM
Okay.. You can see the graph in my last file. It contains three lines and a column for the current week.
But as soon as I change the graph with the slicer, the lines in the graph change to columns.
I'm looking for a method to make a PivotGraph with lines and a marker for the current week.
Jeroen de Graaf
Jan 15 2020 02:24 AM
Jan 15 2020 03:10 AM