Excel charts bar chart with base not at zero - floating boxes

  • Thread starter Thread starter Melissa C
  • Start date Start date
M

Melissa C

I am creating a series of pay grades and want the boxes to "float" or have
their low value above the axis line. I then will have a line or scattergram
with points that fall within these boxes/pay grades.
 
Make a stacked column chart with two series: one for the minimum of the
data, the other for the span (maximum minus minimum) of the data. Format
the bottom bar to be invisible (no border, no area fill).

Then put the point data into two columns, one for the number of the
category from the floating columns (1 for first category etc.), the
other for the Y value. List all points for category 1, then all for
category 2, etc. (This sorting isn't strictly necessary, but it helps
keep things organized.) Copy these two columns, select the chart, and
use Paste Special to add the data as a new series. Right click this new
series (which appears first as another stack on the floating column),
choose Chart Type, and select the XY style, markers only. If necessary,
move this XY series back to the primary axis, so it lines up with the
existing axes.

- Jon
 
Back
Top