Show average discount on chart
Hello, I've currently got a pivot table with information in this format:
Product x Country Net value Discount x 90 10% y 285 5% z 196 2% Total 571 4.8% The chart is showing the countries x, y and z in the x-Axis (primary) and the total net value (primary) and discounts (secondary) in the y-Axis. My net values are displayed as columns, my discounts as dots. I would like to display the average discount 4.8% as a line across all columns. Is that possible? If yes, does anybody know how? Thanks, Eva |
All times are GMT +1. The time now is 01:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com