Linking chart parameters to cells

  • Thread starter Thread starter Franco Turrinelli
  • Start date Start date
F

Franco Turrinelli

Is anyone aware of a way of linking chart parameters
normally set in the various dialog boxes, to a value in a
cell. For example, suppose I'd like the value (Y) axis
minimum and maximum value to change based on the value of
a certain formula, can I somehow link those values to a
cell in the spreadsheet. If not, it'd be cool if I
could. Maybe the next version of Excel?
 
-----Original Message-----
Is anyone aware of a way of linking chart parameters
normally set in the various dialog boxes, to a value in a
cell. For example, suppose I'd like the value (Y) axis
minimum and maximum value to change based on the value of
a certain formula, can I somehow link those values to a
cell in the spreadsheet. If not, it'd be cool if I
could. Maybe the next version of Excel?
.
When you went and created your graph did you reference
Click to expand...
your graph to the cells that contain your formula? Having
your formulas only referenced to cells will automatically
have everything updated. So For example if cell h2
contain this formula =sum(b2:b13) any change with in this
formula will automatically be updated with a new answer.
Having this in mind and having your chart
created/referenced to the cells it will also be
automatically updated. If you have any further questions
or if this is not clear to you please email with your
actual problem ([email protected]). Also this is part
of my enduser help grade for a class.
 
You have to do it programmatically. For a packaged solution limited to
min/max values, check the Excel | Add-Ins | AutoChart Manager page of
my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Normally, having just posted a more accurate response, I would ignore a
wrong post. I realize your response was meant to be helpful and, since
this is for a class, here are some well-intentioned comments.

The OP is interested in chart parameters such as min./max. values for
the axis, not the plotted values themselves. If you try and link them
to cells, it cannot be done.

Also, the plotted cells don't have to have formulas for them to change.
They might be part of a dynamic update from an external data source (a
web query, a database query) a dynamically created table such as a
Pivottable, or a list based on a filter (auto or advanced).

Finally, providing your email address in the body of the post defeats
the purpose of an anonymously made post.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top