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?
- 1 Answers
- 742 Views
- I also Faced
- E-Mail Answers
Answer / Sanatan Hansda
To exclude empty cells when creating a line graph, make sure your data is properly formatted with dates in the format MM/YY or DD/MM/YY. After that, select the range of data (including header), go to Insert > Line Chart, and choose the appropriate chart type.
| Is This Answer Correct ? | 0 Yes | 0 No |
How many worksheets can you have in excel?
How do you compare spreadsheets?
What does a sign mean in excel formula?
How do you combine text in excel?
Where is the sum function in excel?
How does the mid function work in excel?
What is financial modelling in excel?
How do you quickly delete a row in excel?
What is the purpose of sparklines in excel?
How do I customize the ribbon in excel 2016?
Is there a quick way to find tabs in excel?
When I start excel, why do a million files open up automatically?
MS Excel Microsoft 
