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 Please play around with the file by changing the values in the yellow marked cells. Thank you for your reply. My ...
Yes, the essence of my goal is to create visual which contains sales columns as usual, previous photo, also adding that new lines will be separated (the lines number depends on selected years in the slicer ( number of lines equal to number of selected years and so on.) How to...
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 y...