Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Software & Technology
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions

Entry Level
Actuarial Jobs

Casualty, Health

Pensions
Life, Investments

DW Simpson & Co.
Actuarial
Recruitment
Worldwide

Casualty Jobs
& Property -- Worldwide
Reinsurance,

Insurance, Bureaus & Consulting

Salary Surveys
Life & Health

Pension
Property & Casualty


 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-24-2006, 02:59 PM
Aeyyyyyy's Avatar
Aeyyyyyy Aeyyyyyy is offline
Member
 
Join Date: Oct 2005
Location: Milwaukee, WI
Posts: 2,462
Thumbs up Excel charts: Making the scale values a reference

Is it possible to make the minimum and maximum scale values for a chart a reference to some sheet?

For example, when I click "Format Axis...", I'd like to be able to do something like type in "=Sheet1!A5" in the Minimum field, or do something that accomplishes the same thing. I could go the long way and make the chart update with a macro for certain change events, but it would be much nicer if this could somehow be worked in simply.

Any ideas?

Aeyyyyyy!
Reply With Quote
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 11:07 PM.


Powered by vBulletin®
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.12298 seconds with 8 queries