I am looking to automatically update a scatter chart when the data in a cell is changed:
Col A Col B Col C
Returns Standard Deviation
Bond A 1.50% 16.63%
Bond B 2.75% 15.10%
Bond C 1.69% 15.63%
So if the value in col b or c changes I will need the graph to automatically update? Thanks for any help.
Last edited by matteo216; 09-20-2010 at 04:09 PM.
What exactly is the question? Every Excel chart updates when the underlying data changes.
I actually need the center axes of the xy scatter chart to re center depending on the data?
How was anybody suppose to guess that from your original post
Post a workbook with a example of how you think the chart should look.
Axis parameters can not be linked to cell so it is more than likely going to require a VBA solution.
That said it maybe possible to cause the chart to adjust by using dummy data.
I need the horizontal and vertical axis crosses to automatically update each time the data in cells b30 and c30 are updated. I need the center axis to be linked to those cells if possible. I am attaching a worksheet. Thanks for the help.
Given the min and max are also fixed values you will need to use a code based solution.
http://peltiertech.com/Excel/Charts/...nkToSheet.html
With the code will the min and max values also automatically adjust? Thanks for all the help.
You just need to tweak the code changing the CrossesAt value
Please Login or Register to view this content.
Thanks, but I am not very experienced in VBA to know how to do all of this just thought I could link it to a cell. Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks