Graph Question

[Liverpool1959]

I have a simple Spreadsheet with 3 Columns,"Date, Revenue and Cost." I have highlighted the 3 Columns as my Data for the Graph. I have deleted all the Rows that would be Saturday or Sunday. So column A has Jan 1-5, there is no Jan 6 or 7 and then picks up with Jan 8.

However, the Bar Graph still shows the dates for the Saturdays and Sundays. An idea how to remove them from the Graph?

 

[Gerald Higgins]

I'm guessing that if you right click on the chart axis that contains the dates, in the Axis Options dialog box, under Axis Type, you will have EITHER selected the option for "Automatically select based on data" OR the option for "Date Axis".

Try selecting the option for "Text Axis"