Willow Solutions, Inc. Leaf graphic
Willow SOlutions, Inc. Software that thinks like you do
News
Products
Case Studies
Tips
Willow Talk
Clients
Partners
Job Openings
Home

Willow Tips

 
 

Tip #2000-3: Make your Excel charts update dynamically

 

The Chart Wizard

Here are the five steps of the Chart Wizard. The most important step is Step 1. Remember to change the range to the two dynamic range names: ChartDate and Yld30.

The last step, after the Chart Wizard has created the chart on your worksheet, is to format the chart's Y axis to a different scale, so that we can better see the daily changes.

  1. Double click on the chart to activate the chart
  2. Click on the Y axis to bring up the Format Axis box
  3. Click on the Scale tab
  4. Change the minimum to 5.75 and the maximum value to 7.5

 
Back to Tip

  What's New | Products | Case Studies | Willow Tips | Willow Talk | Clients | Partners | Job Openings | Home
  Terms of UsePrivacy Statement
Willow Solutions, Inc.85 Willow Street, New Haven CT 06511 USA203.777.5634info@willowsolutions.com