Chart Update

**_darkness** · 11-02-2008, 11:05 AM

Thanks. I made a gantt chart for this. I need this gantt chart update itself when ever new data entry happens. İs this possible?

Also I will sort this data only for "h" column whenever I sort it I want just sorted data to be shown on gantt chart .İs there a way to do this?

And any ideas to show this gantt chart better?

File : http://rapidshare.com/files/159955654/example4.xls

Thanks in advance guys..

**arthurbr** · 11-02-2008, 11:11 AM

No offense meant, but why do we have to look at an advertisement for a long while you can attach a file in this forum?
This looks more like spamming than trying to solve a question...

**_darkness** · 11-03-2008, 02:07 AM

Originally Posted by arthurbr

No offense meant, but why do we have to look at an advertisement for a long while you can attach a file in this forum?
This looks more like spamming than trying to solve a question...

hey!! I tried that okey,it is not working.İt says " Database error" .You gotta to know everything around here since you are moderator but I believe you don't so can we concentrate on a question please.No offense.

**Andy Pope** · 11-03-2008, 05:33 AM

Consider using Named ranges for you chart data source.
Plenty of examples on forum

**_darkness** · 11-03-2008, 06:04 AM

I got formula errors every time I tried it.Help would be nice..

**Andy Pope** · 11-03-2008, 06:21 AM

So what have you tried?

**_darkness** · 11-03-2008, 06:34 AM

Originally Posted by Andy Pope

So what have you tried?

I try to add the following named formulas:

ChartDataHeaders=OFFSET(Summary!$H$1,0,COUNTA(Summary!$H$:$H$)-1)
ChartDataSeries1=OFFSET(Summary!$I$2,0,COUNTA(Summary!$H$1:$H$1)-1)

**Andy Pope** · 11-03-2008, 07:24 AM

for some reason column H153 onwards is treated as text.

Use these 2 named ranges.

ChartDataHeaders: =OFFSET(Summary!$H$1,1,0,COUNT(Summary!$H:$H),1)
ChartDataSeries1: =OFFSET(ChartDataHeaders,0,1)

If you are using xl2007 then change the names to not include the word Chart

**_darkness** · 11-03-2008, 07:38 AM

Thanks Andy but I dont know why this is not working. Can you please send me an example ..

**Andy Pope** · 11-03-2008, 07:41 AM

see attached. I have removed surplus records to reduce filesize.

**_darkness** · 11-03-2008, 08:17 AM

Thanks.When I add data on "h" column I can see it on the graph but I need to see "I" column aswell.İf we can do this,I am through with this thing.

**Andy Pope** · 11-03-2008, 08:26 AM

You need to update the second data series as well to use named ranges rather than fixed cell range.

Is you chart correct in that column I is used for both the padding and data bar?

**_darkness** · 11-03-2008, 09:00 AM

yep it is Andy.

And i keep getting errors.. " A formula in this worksheet contains one or more invalid references." I got this error even when I sum a+b .I believe my excel is dead.