Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Joseph Sayah
 
Posts: n/a
Default Swing Chart with dynamic Range

I would like to create a swing chart (stock chart) with a dynamic range that
grows as more data is added.

Any ideas?

Thank You
Joe
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Swing Chart with dynamic Range

Hi,

For information on the dynamic ranges have a read of Jon Peltier's page
http://peltiertech.com/Excel/Charts/Dynamics.html

Depending on which stock chart you want you will need 3 to 5 named ranges.

Cheers
Andy

Joseph Sayah wrote:
I would like to create a swing chart (stock chart) with a dynamic range that
grows as more data is added.

Any ideas?

Thank You
Joe


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta
 
Posts: n/a
Default Swing Chart with dynamic Range

In addition to Andy's suggestion, you may also want to check
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
I would like to create a swing chart (stock chart) with a dynamic range that
grows as more data is added.

Any ideas?

Thank You
Joe

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
Problem with Slow ReCalculation of Dynamic Range Using OFFSET Kris_Wright_77 Excel Worksheet Functions 2 November 18th 05 11:18 AM
Dynamic bar chart, must ignore "n/a" data... paris3 Charts and Charting in Excel 4 June 26th 05 07:07 PM
dynamic end on chart Donna YaWanna Charts and Charting in Excel 1 June 17th 05 04:50 PM
Dynamic Print Range Help waxwing Excel Worksheet Functions 2 February 21st 05 04:47 PM
Add a Dynamic Range with 2 Conditions Q John Excel Worksheet Functions 7 December 23rd 04 03:58 PM


All times are GMT +1. The time now is 10:03 AM.

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

About Us

"It's about Microsoft Excel"