#1   Report Post  
Old May 19th 09, 04:01 PM posted to microsoft.public.excel.charting
noy noy is offline
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 8
Default Floating Charts

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

  #2   Report Post  
Old May 19th 09, 04:14 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 2,489
Default Floating Charts

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


  #3   Report Post  
Old May 20th 09, 02:56 PM posted to microsoft.public.excel.charting
noy noy is offline
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 8
Default Floating Charts

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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Floating charts Rob Kattenburg Charts and Charting in Excel 2 June 28th 08 06:14 PM
Floating Bar CHarts Rahul Charts and Charting in Excel 1 September 26th 07 09:13 AM
Floating Bars on Line-Bar Charts? jaygreg Charts and Charting in Excel 8 July 19th 07 03:06 PM
Floating row? pause café Excel Discussion (Misc queries) 2 January 24th 07 11:47 PM
Floating Key Mr-Re Man Excel Discussion (Misc queries) 1 March 21st 06 12:08 AM


All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017