Excel plot error

Excel plot will fail in automatic data, axis, or legend selection for one or more the following reasons:

A. First cell on column top is not an alphanumeric cell. If the first cell of the column is a numeric cell only, then plot will fail. Solution: rename data in first cell to be an alphanumeric title of the column, or create such a title cell.

B. Empty cells which actually contain improper data, such as NaN, #REF, etc.

C. Textual or alphanumeric data in any cells will cause excel plot error. All cells below the first cell of the column must contain proper NUMERIC contents only, and must be formatted as NUMERIC.


Sometimes, plot will fail in seemingly good numeric cells data. If you find this, then plot partial amount of data (do not go down all the way in your selection) until you find the offending cell.

˅˅˅ Additional valuable information is available at one of the links below: ˅˅˅


Did you like the article? Let Google Search know by clicking this button: . Please link to content that you find useful on this website on your own website, forum or blog! You can also comment on this page below, or to ask a question or suggest a topic for me to research. There is a user-editable Wiki available on my website, as well as a Forum that you can contribute to. Site Map.

Page last modified 31-Dec-12 21:25:24 EST
Comments on this page: