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

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"noy" wrote in message
...
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

Hi Andy - Thanks for that worked a dream.

Cheers


Noy

"Andy Pope" wrote:

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"noy" wrote in message
...
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