Forum Discussion
Axis change means data no longer fill chart
I have a chart with weekday dates on the horizontal axis and data for both a primary and a secondary axis. Because the weekend dates show up as spaces in the chart, I changed the Axis Type to "Text Axis". The data now displays without spaces, but the data set is now displayed on only the left 2/3 of the chart space. I assume that the shrinkage occurs because the empty spaces have been removed. Any suggestions for how I can make the data fill the chart space?
Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
