Seamus2626
asked on
Super impose a line graph on a bar graph
Hi,
I have some data from 5 regions on a bar graph, it shows average values of deals for each region
I would like to somehow show the median values on the same graph to visually show the difference between Average deal size and median deal size
I have attached the file - its chart Avg vs Median and the data for median is in tab "Data" N16 - We are only interested in Totals for each region "ASP, EU, LA, ME, NA"
Many thanks
RD-Analysis-light.xlsx
I have some data from 5 regions on a bar graph, it shows average values of deals for each region
I would like to somehow show the median values on the same graph to visually show the difference between Average deal size and median deal size
I have attached the file - its chart Avg vs Median and the data for median is in tab "Data" N16 - We are only interested in Totals for each region "ASP, EU, LA, ME, NA"
Many thanks
RD-Analysis-light.xlsx
ASKER
Yep, exactly....thanks Glenn
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thats brilliant Glenn! Please though, if there is a better method re-arranging my raw data, i would love to see it!
I did make a couple of modifications. First, I added a series label cell for the Median Line above the series (Data sheet, G14). Second, I created a standardized formula to pick up the median value on for those region-categories NOT "CMB", "FI", or "GBM". These are in cells G16:G35 on the Data sheet.
-Glenn
EE-RD-Analysis-light.xlsx
-Glenn
EE-RD-Analysis-light.xlsx
ASKER
Thats very kind of you Glenn!
-Glenn