SOLVED
Home

Excel chart problem

%3CLINGO-SUB%20id%3D%22lingo-sub-313034%22%20slang%3D%22en-US%22%3EExcel%20chart%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313034%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20created%20a%20bar%20chart%2C%20but%20one%20figure%20is%20not%20transferring%20from%20the%20data%20to%20the%20chart%20area.%26nbsp%3B%20I%20cannot%20work%20out%20why.%26nbsp%3B%20Can%20anyone%20help%20please%3F%26nbsp%3B%26nbsp%3BPlease%20explain%20in%20simple%20language%2C%20I%20am%20a%20beginner%20and%20self-taught!%26nbsp%3B%20Thank%20you.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-313034%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20chart%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313200%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20chart%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313200%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313195%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20chart%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313195%22%20slang%3D%22en-US%22%3E%3CP%3EOh%20how%20silly%20of%20me!%26nbsp%3B%20Thank%20you%20very%20much%20for%20such%20quick%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313177%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20chart%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313177%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20is%20since%20you%20Y%20axis%20starts%20from%2070.%20If%20you%20change%20on%2060%20(or%20whatever%20is%20less%20than%2070)%20the%20column%20for%20G%20will%20be%20visible.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20487px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F65766i307C359BE463995E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313166%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20chart%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313166%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20really%20have%20the%20right%20language%20to%20explain%2C%20but%26nbsp%3BI%20have%20attached%20the%20document.%26nbsp%3B%20%26nbsp%3BThe%20value%20of%2070%20in%20column%20G%20is%20not%20showing%20in%20the%20chart.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-313138%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20chart%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-313138%22%20slang%3D%22en-US%22%3E%3CP%3EWithout%20the%20file%20or%20more%20detailed%20explanation%20it's%20hard%20to%20say%20something%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have created a bar chart, but one figure is not transferring from the data to the chart area.  I cannot work out why.  Can anyone help please?  Please explain in simple language, I am a beginner and self-taught!  Thank you.

5 Replies
Highlighted

Without the file or more detailed explanation it's hard to say something

Highlighted

I don't really have the right language to explain, but I have attached the document.   The value of 70 in column G is not showing in the chart.  

 

Many thanks

 

 

Highlighted
Solution

That is since you Y axis starts from 70. If you change on 60 (or whatever is less than 70) the column for G will be visible.

 

image.png

Highlighted

Oh how silly of me!  Thank you very much for such quick help.

Highlighted

You are welcome