Graph that omits Saturdays and Sundays

Hi all,

In the enclosed workbook you'll find a graph that reads from a dataset that does not contain any values for Saturdays or Sundays. But, the graph still includes weekends but with zero values.

Is it possible to make some changes such that there is no open 'spaces' for Saturdays and Sundays in the graph?

Thanks :)
Graph.xlsm
UtredningAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

Goto Format Axis / Axis Options /Axis Type / Text axis

Regards
EDIT File
GraphV1.xlsm
0
All Courses

From novice to tech pro — start learning today.