Prev: Trendline when data points are missing
Next: adding data to the chart is unavailable
From: KHAN on 11 May 2010 19:21

I have 2 questions and really need your help
1.I have data sheet and chart sheet.I am not using pivot table.For each new
day I am adding one line for current day data to data sheet.I have around 60
charts.How can I get charts updated automatically.I am currently selecting
each chart and extend data for adding one more line everyday to those 60
plots.(right click -selecting data and one more row from table) and it takes
a lot of time.
2.Is there anyway to embed bubble (comment) data to specific date in axis.I
have comments in bubbles for each day but they are shifting when I put new
day's data.So I need to shift back them to the correct location(date)
everyday.

Thanks in advance!

--
KHAN
From: trip_to_tokyo on 12 May 2010 09:08
EXCEL 2007

“How can I get charts updated automatically.”

You need to create Tables for your underlying data.

I have just put up a chart to illustrate how this is done at:-

http://www.pierrefondes.com/

Item number 104 (Dynamic Range Chart).

This is an example of one way in which you might achieve your objective.

If you look at the Worksheet I have put up step by step instructions
(starting at cell D 24) as to how to add the Table.

You can then add a further 2 rows of data (following my numbered
instructions) and you will see the Chart update automatically.

If my comments have helped please hit Yes.

Thanks.



"KHAN" wrote:

>
> I have 2 questions and really need your help
> 1.I have data sheet and chart sheet.I am not using pivot table.For each new
> day I am adding one line for current day data to data sheet.I have around 60
> charts.How can I get charts updated automatically.I am currently selecting
> each chart and extend data for adding one more line everyday to those 60
> plots.(right click -selecting data and one more row from table) and it takes
> a lot of time.
> 2.Is there anyway to embed bubble (comment) data to specific date in axis.I
> have comments in bubbles for each day but they are shifting when I put new
> day's data.So I need to shift back them to the correct location(date)
> everyday.
>
> Thanks in advance!
>
> --
> KHAN
 | 
Pages: 1
Prev: Trendline when data points are missing
Next: adding data to the chart is unavailable