Dynamic column chart - auto sort on data range

=?Utf-8?B?amltZnJvZw==?=

Guest

Posts: n/a

29th Mar 2006

I have a column/bar chart that updates every day using defined names. It
shows the last 30 days of data summed together in one bar for 23 different
machines. The first column of the data is the date; the first row is the
machine discription. I want the data to auto sort in the row whenever it is
updated. This will in turn sort my column chart from high to low.
Can anyone help?

« flow chart | Change source according to data entered in a template. »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
3d column chart dynamic range	MikeF	Microsoft Excel Programming	0	5th Jun 2010 07:03 PM
Chart empty with new data in the dynamic range chart.	Feejo	Microsoft Excel Misc	16	3rd Jan 2008 10:03 PM
Can you make a chart's data always refer to a dynamic range name?	Chrisso	Microsoft Excel Charting	2	24th Aug 2007 12:30 PM
Dynamic range as chart data source	BillS	Microsoft Excel Misc	2	20th May 2004 12:36 PM
Static Range, Dynamic Chart Data	airbob	Microsoft Excel Charting	3	6th Feb 2004 08:42 PM