I'm working on a project where I want to show price gaps for a given product against some competitors (better to have a larger negative price gap or smaller positive price gap to competitors).
Each competitor would be a separate vertical bar and the range could be all negative ($-0.10 to -$0.20) or the range could be positive to negative ($0.05 to -$0.05) or lastly all positive ($0.50 to $0.60).
As you can see below the 'range' of these price differences are all just $0.10 from maximum to minimum. However when I do these as a stacked bar with hiding the first bar, I'm using hidden stacked bar since I need to use the 'hidden bar' just as a data point for the start of the data range, the size of the bar can be disproportionate across the three competitors (all have a price gap of $0.10).
The range that is all positive looks the largest since a stacked bar just adds to the first bar....the first part of the bar = $0.00 to +$0.50 is hidden but shows the +0.50 for the start of the range as the data point from the hidden bar, but then the second bar is shown as a data point for +$0.60 and the 'size of the bar is therefore $0.60 added to the $0.50 hidden
'.
I didn't see any charting range functions as vertical bars in excel. Is it possible to do this another way? I want to stay away from anything that forces me to enter data as text boxes as I would rather have the data entered into the data table show automatically.
Each competitor would be a separate vertical bar and the range could be all negative ($-0.10 to -$0.20) or the range could be positive to negative ($0.05 to -$0.05) or lastly all positive ($0.50 to $0.60).
As you can see below the 'range' of these price differences are all just $0.10 from maximum to minimum. However when I do these as a stacked bar with hiding the first bar, I'm using hidden stacked bar since I need to use the 'hidden bar' just as a data point for the start of the data range, the size of the bar can be disproportionate across the three competitors (all have a price gap of $0.10).
The range that is all positive looks the largest since a stacked bar just adds to the first bar....the first part of the bar = $0.00 to +$0.50 is hidden but shows the +0.50 for the start of the range as the data point from the hidden bar, but then the second bar is shown as a data point for +$0.60 and the 'size of the bar is therefore $0.60 added to the $0.50 hidden
I didn't see any charting range functions as vertical bars in excel. Is it possible to do this another way? I want to stay away from anything that forces me to enter data as text boxes as I would rather have the data entered into the data table show automatically.
