Hello experts
I have a file with sales figures where in row 1 are my table headers (months) and in the following rows are my customers and years (A2=customer name A, B2=2015, B3=2016 and so on).
Is it possible to have one chart for which I can select the customer and show 2015 in a line graph and 2016 in a bar graph?
I've been trying with a pivot table and chart, with slicers, but without good results. Apparantly I always have to enter the customer's name before each year (A3 in this case). This makes the file less clear.
Dummy file attached.
All solutions are welcome.
Thanks
Chris
Bookmarks