Microsoft Excel Question:
Download Questions PDF

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 be represented as zeroes in the line graph. Is there a way to graph all months without displaying the zero values?

Answer:

This can be accomplished by going to Tools, Options, menu, choose the Graph Tab, under "Plot empty cells as" option, Select, "not plotted (leave blank)".

Download MS Excel Interview Questions And Answers PDF

Previous QuestionNext Question
In Excel, how can I prevent a row from printing in a range if certain cells in a particular column equal 0. I do not want to extract the records to another section of the sheet. Is it possible to hide those rows, then print, then unhide?I am using Excel and I want to print only the bottom of the worksheet. There is not an option to do this in the print dialog box. How can this be done?