Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show average value as a horizontal line in a column chart | Charts and Charting in Excel | |||
do not show zeros in pivot chart (pie chart) | Charts and Charting in Excel | |||
average cells, show 0 if nothing to average | Excel Discussion (Misc queries) | |||
Show average at front of list | Excel Discussion (Misc queries) | |||
Show weighted average value after filter. | Excel Worksheet Functions |