LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Peter Nagy
 
Posts: n/a
Default

Tushar: addendum to my first reply:

It would be acceptable to maintain each chart as a separate workbook with
some kind of hyperlink back to the original data source table.

-Peter

"Tushar Mehta" wrote:

While I have never created (or tried to create) 300 charts in a single
workbook, it is easy to believe that performance and stability of Excel
might become a question.

Do you have to have 300 charts? Or will one chart (or a few) that can
be easily changed to reflect new data suffice? If so, adapt the ideas
behind
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
specifically, the examples in 4 through 6.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2005

In article , "=?Utf-
8?B?UGV0ZXIgTmFneQ==?=" <Peter says...
I am attempting to create a separate chart for each row of my worksheet
(about 300 rows = 300 separate charts). Is there an easy way to do this?
The actual data range will change month-to-month, so I would not want to
have to recreate 300 new charts each month individually.


 
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
How to create a line chart with two X-axes in Excel JaVaughn Excel Discussion (Misc queries) 2 June 29th 05 04:52 PM
Excel 2002 chart does not update when worksheet data changes proquant Charts and Charting in Excel 1 June 15th 05 12:23 AM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM
Create a custom chart, two stacked bars/month w/ two axes? Oscar Charts and Charting in Excel 1 March 21st 05 11:07 PM
Is there a way to create a standard OHLC bar chart in Excel? [email protected] Charts and Charting in Excel 3 December 2nd 04 09:49 PM


All times are GMT +1. The time now is 12:42 PM.

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

About Us

"It's about Microsoft Excel"