Posted to microsoft.public.excel.misc

Paul

Posts: n/a

Charting External Data...

I have an area of my spreadsheet that contains data acquired from an external
ODBC database. I have 3 charts that chart various portions of the data
returned. There are 4 series in each of the charts. I have two questions;

1) Since I do not know number of rows that will be returned how do I define
the series such that it will use all the rows returned?

2) How do I force an update of the charts when the data is refreshed?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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
Excel Macro to Copy & Paste	[email protected]	Excel Worksheet Functions	0	December 1st 05 01:56 PM
Charting Data Series vs. Data Points?	Tommy Z.	Charts and Charting in Excel	4	November 29th 05 11:23 PM
External Data	Andrew Hills	Excel Discussion (Misc queries)	0	April 29th 05 02:38 AM
How do I create a list in excel that contains external data?	bill@bb	Excel Discussion (Misc queries)	1	February 15th 05 02:45 AM
Fetching External Data from Excel	Sri	Excel Discussion (Misc queries)	2	January 3rd 05 11:46 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us