Prev Previous Post   Next Post Next
  #1   Report Post  
Loi
 
Posts: n/a
Default Charts

Hi,
I have a sheet which have two columns - A and B.

Column A Column B

Class2 at cell(A2) 9 (B2)
Class3 (A3) 6 (B3)
Class4 (A4) 10(B4)

I create a bar char by seclecting Class2--to Class4 and 9--
to 10. I works fine.

My question is that there is a way which the chart will
update by itself if I put in Class5 in column A and 11 in
column B.

Ex: If I insert a new row (Row5) and type in Class5 and 11
(B5), can it update the chart by itself?

If you think that there is a way that can make the chart
can update by itself, please show me.

Thank you
Loi
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
How do I remove empty chart plots from linked worksheet charts Lee IT Charts and Charting in Excel 3 January 31st 05 04:31 PM
combing two bar charts to share one axis Penny Charts and Charting in Excel 3 January 27th 05 05:15 PM
initial size of new charts bob m Charts and Charting in Excel 1 January 22nd 05 02:19 AM
To get a lot of charts that contain different values in a minute Kevin Charts and Charting in Excel 0 December 28th 04 06:45 AM
pie charts - how to include "zero" fields on Legends Doug VanOrnum Charts and Charting in Excel 0 November 30th 04 04:49 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"