If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel charts bar chart with base not at zero - floating boxes
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. |
#2
|
|||
|
|||
Excel charts bar chart with base not at zero - floating boxes
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 ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Melissa C wrote: 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. |
#3
|
|||
|
|||
Excel charts bar chart with base not at zero - floating boxes
|
Thread Tools | |
Display Modes | |
|
|