Brendan Hughes

I've got a data table of 30 rows. Each row has a monetary amount represented by a min and max value - might be 0-500, might be 0-5000, or might be 500-8000, etc.

I'd like to have these visible on a chart, like a bar chart, where some of the bars won't start from 0.

I've managed to do it more or less using the "stock" chart type, which requests a "high-low-close", so I put in a dummy middle value, but I only succeed getting the presentation in lines, rather than thick bars, and they look a bit skinny and feeble TBH. Another "stock" type allows bars by including a fourth value (the thickness represents another dimension), which I played with but couldn't fool into doing what I wanted.

Anyone got a good idea on how to change the lines to bars?

Many thanks

TopBanana

Floating bars?

Brendan Hughes

Me fick - please explain? Yes that sounds like what I want, how do I get it?

TopBanana

On my version (2003) it's under Insert -> Chart... Custom Type tab.

Dunk

iTrader: (1)

PM me you mail address & I'll send you a template that should help.

D

TopBanana

Always got to go one better havent you?

Dunk

iTrader: (1)

1 - 5 better actually

D

TopBanana

You'll get yours matey

RMA26

http://www.mrexcel.com/board2/

Brendan Hughes

OK, I tried with floating bars on Friday but couldn't get it to work out which were the datasets and how I wanted them presented - so Dunk, you have PM!