Dynamic Charts

TryingToHaveFun · #1 02-05-2011, 10:44 PM

I'm trying to create a chart with 30 days of information, when I add the 31st day, day 1 drops off, when I add day 32, day 2 drops off and so on. Does anyone know anything I can read to guide me?

Thanks
TryingToHaveFun

Colin Legg · #2 02-06-2011, 03:43 AM

Hi,

This can be done by using a dynamic named ranged. Have a look at this example on Tushar Mehta's site:
http://www.tushar-mehta.com/excel/ne...tml#LastSoMany

Hope that helps...

Kimberly · #3 02-06-2011, 11:01 AM

In Office 2007 or 2010, you can click in the data source, click Format as Table on the Home tab... Instant dynamic range. Insert a chart using this table.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic footer	WalterinOz	Word	1	12-22-2010 11:08 PM
A dynamic date to show up on the last page only	jackaroo	Word	1	08-18-2010 01:26 PM
Dynamic alignment?	Corporem	Word	1	05-20-2010 10:55 AM
Dynamic Charts...	herbycanopy	Excel	3	04-09-2010 05:58 PM
Identifying the Dynamic Connector	cyberbhai	Misc	0	12-14-2005 03:55 AM