OfficeTips Home || VBA Section || General Section ||  Download Section  ||  Privacy Policy

Delete the links from a chart to the data range on a worksheet

You can convert the formula so that it contains an array of values instead of pointing to the data range on the worksheet. To do this, use the following steps:
  1. Click the chart to activate it.
  2. Select a series.
  3. Click the formula bar so that the insertion point is blinking in the formula bar.
  4. Press Ctrl + =, or press F9 (They both provide the same functionality).
  5. Press Enter.

 

 

Copyright 1999-2018 (c) Shyam Pillai. All rights reserved.