Home

Excel Graph Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-401467%22%20slang%3D%22en-US%22%3EExcel%20Graph%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-401467%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20excellers%2C%3C%2FP%3E%3CP%3Erecently%20excel%20reported%20a%20repair%20need%20when%20I%20tried%20to%20open%20my%20file%20and%20at%20the%20end%20deleted%20existing%20charts%3B%20after%20this%20happened%20excel%20does%20not%20allow%20me%20to%20add%20charts.%3C%2FP%3E%3CP%3EThe%20message%20is%20as%20follows%3A%3C%2FP%3E%3CP%3E%22%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%3ESelect%20the%20cells%20that%20contain%20the%20data%20that%20you%20want%20to%20use%20to%20create%20the%20chart.%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3EIf%20you've%20named%20rows%20and%20columns%20and%20want%20to%20use%20them%20as%20labels%2C%20add%20them%20to%20your%20selection.%3C%2FSPAN%3E%3C%2FSPAN%3E%22%3C%2FP%3E%3CP%3EDid%20you%20experience%20such%20a%20situation%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-401467%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Baburcan
Occasional Visitor

Hi excellers,

recently excel reported a repair need when I tried to open my file and at the end deleted existing charts; after this happened excel does not allow me to add charts.

The message is as follows:

"Select the cells that contain the data that you want to use to create the chart. If you've named rows and columns and want to use them as labels, add them to your selection."

Did you experience such a situation?

 

Related Conversations
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Date Formatting Won't Change
Steve Gould in Excel on
10 Replies
Format Date in header and footer
Joe Cangelosi in Excel on
3 Replies
Conditional Formatting values across tables
ChrisJP in Excel on
5 Replies
Adding Display Zero as Dashes to Custom Excel Number Format
emmagreen in Excel on
1 Replies