Floating Charts

[noy]

Hi

I have a set of data shown below. I would like to show them on a floating
graph with the High and the Low for each set of data (e.g. A's hi and low)
connected together using a line with a cross and the end to show the high and
the low.

A B C D E F
Low 45 15 12 10 10 15
Hi 52 25 45 80 15 125

I can do it using a floating bar - but it doesn't really achieve the effect
I'm after. Anyone got any useful tips?


Cheers

Noy

 

[Andy Pope]

Hi,

Start by creating a line chart.
Format one of the series. Format dialog, Options tab, High-Low lines.

Now format each series to have no Border and cross data marker.

Cheers
Andy

 

[noy]

Hi Andy - Thanks for that worked a dream.

Cheers


Noy