refresh graph data

anantathaker

Board Regular
Joined
Jan 7, 2005
Messages
71
i have a line graph that is linked to a column of data, but i have calculation set to "manual" in tools>options because of the large size of the file. when i press f9, the graph doesn't update if i've changed the data. is there another way to do this? how can i manually update the graph but have it update immediately when i press whatever command/key is necessary? thanks!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Reid

Well-known Member
Joined
Oct 29, 2004
Messages
593
The graph should redraw when you press F9. It sounds to me like you may have a problem with your source data definition. Right click on your chart, choose "Source Data..." and then click the "Series" tab. Click on each series in the box on the left and make sure that the range in the "Values:" box on the right is pointing to the right place.
 

NdNoviceHlp

Well-known Member
Joined
Nov 9, 2002
Messages
2,803
You could VBA refresh your chart if you want to add a command button to your page and push it to call a macro after you've updated your data. You might have to "unlink" your data first? Here's a link that may be of some use... or you could just wait for Jon to help you out... or go to his site for lots of good stuff (previously posted link). HTH. Dave http://www.mrexcel.com/board2/viewtopic.php?t=191465&start=10
 

Forum statistics

Threads
1,141,286
Messages
5,705,517
Members
421,399
Latest member
hjweiss00

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top