Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Not that I know of...
"Loi" wrote: 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 |
#3
|
|||
|
|||
Hi Loi
There are numerous links available here to show you how to create a dynamic chart. http://peltiertech.com/Excel/Charts/...hartLinks.html Cheers Andy Loi wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
Thank you very much ! Ady. I got it.
-----Original Message----- Hi Loi There are numerous links available here to show you how to create a dynamic chart. http://peltiertech.com/Excel/Charts/...hartLinks.html Cheers Andy Loi wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I remove empty chart plots from linked worksheet charts | Charts and Charting in Excel | |||
combing two bar charts to share one axis | Charts and Charting in Excel | |||
initial size of new charts | Charts and Charting in Excel | |||
To get a lot of charts that contain different values in a minute | Charts and Charting in Excel | |||
pie charts - how to include "zero" fields on Legends | Charts and Charting in Excel |