Charts in Excel

Hot Topic

Assign range to array
handling volume control in C#
printing .doc, .xls, and .pdf files from a list of filenames using an excel vba macro
Collections of control - evaluating the name of a control that has been "pressed"
Trying to get VB to update charts in Excel
Setting Chart Title through VBA sometimes works sometimes doesn't.
disabling buttons in a list form
Generate XML from Excel Data
VB & VBA - page setup options completely disappear after merging a document
Office 10 \ winword.exe runtime error

Microsoft ISV

Access 2003 - programming arrow keys with combo box
Please help me to print the label for this condition
Access Project and Views
Copying and pasting between spreadsheets
inputbox method and ranges
Collections of control - evaluating the name of a control that has been "pressed"
Internet Explorer Problem?
Can I get Micorsoft.RuleEngine.dll ?
Excel Solver VBA Problem
Problem about the "Find" function in VBA editor

Charts in Excel

I am using defined names to automaticly update my charts.

I am using the =OFFSET and =RAND

I do have some cells that contain #VALUE!

It seems like the chart will update but only part of it. For example it will update but miss the last point.

My question is could a non-value cause it to not update correctly

Thanks

Tiger

Answer this question

Charts in Excel

  • Jim Agla

    The first thing to do is check htat your defined names accurately pick up the right sized range. If you use COUNT() and the range contains an error, the error will not be counted, so your resulting range will not be as large as you expect.

    To see what range is defined by the name, open the Define Name dialog (Ctrl+F3 is a handy shortcut), select the anem, and click in the Refers To box. The range it refers to will be highlighted.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Peltier Technical Services
    Tutorials and Custom Solutions
    http://PeltierTech.com/
    _______



  • Charts in Excel
Answer this question