How do you plot a value range on a bar graph...

**bagogyal** · 04-07-2012, 06:21 PM

I'm trying to plot salary ranges in to a graph but don't know how to input info into excel

ex. Less than 1 year $24,417 - $32,938

PLEASE HELP!

**Richard Buttrey** · 04-07-2012, 06:45 PM

Hi,

Your post is unclear - at least to me. Please upload an example workbook indicating the values you wan to see plotted on the x & y axes. And if you can draw an example picture and upload or incorporate in the workbook so much the better.

It is always easier to advise if we can see your request in its context.

**bagogyal** · 04-07-2012, 07:25 PM

I don't see the attachment button to attach the sample...please advise.

**bagogyal** · 04-07-2012, 07:32 PM

Ok Richard, I hope I uploaded correctly...waiting for your reply.

**Andy Pope** · 04-08-2012, 04:56 AM

You can use a stacked bar chart.
If you include a repeat of the top band you can use data labels on the 1st and 3rd series to label the lower/upper pay bands.