I have a chart with days in the x-axis. My source data only has business
days, but they show up on the chart with 0 data. How can I remove those days
from the chart?
I have a chart with days in the x-axis. My source data only has business
days, but they show up on the chart with 0 data. How can I remove those days
from the chart?
Hi,
Right click the chart and pick Chart Options.
On the axis tab set the X axis to be Category rather than Automatic or time.
Cheers
Andy
Terence wrote:
> I have a chart with days in the x-axis. My source data only has business
> days, but they show up on the chart with 0 data. How can I remove those days
> from the chart?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks