I am using excel, and want to create a line graph with the data on my spreadsheet, ranging from january to december. However, I don not want the empty cells to berepresented as zeroes in the line graph. Is there a way to graph all months without displaying the zero values?

638

While entering a series of numbers I was manually entering a comma. Excel auto-formatted the field to accommodate the comma like 1,200. I erroneously entered12,00. Obviously the comma was placed in the incorrect position, but excel interpreted this as text. When I wrote my sum formula, the results were not as expected.how can this be avoided in the future?

637

What are the components of ms word?

575

What language is excel written in?

791

How do you clean data in excel?

600

How do you merge two cells together?

586

Who created fonts?

569

How do you check a value in a range in excel?

665

How do I compare two excel 2010 spreadsheets?

638

What are computer shortcut keys?

574

How can you make a video in powerpoint?

347

How do you create a blank document in word?

596

What is sum excel?

622

What is the keyboard shortcut for the brush tool?

757

What is the font size in ms word?

581