I have a spreadsheet which I record fortnightly data in. When I create a
chart, the chart is picking up the days in between the fortnight dates and
messing up my graph. I only want to show the actual dates ie the each
fortnight in my chart
I have a spreadsheet which I record fortnightly data in. When I create a
chart, the chart is picking up the days in between the fortnight dates and
messing up my graph. I only want to show the actual dates ie the each
fortnight in my chart
Hi,
Sounds like you need categorical axes rather than time series.
Right click chart and from the popup menu chose Chart Options. On the
Axes tab set the X axis to being Category rather than Automatic.
Cheers
Andy
Frustrated Charter wrote:
> I have a spreadsheet which I record fortnightly data in. When I create a
> chart, the chart is picking up the days in between the fortnight dates and
> messing up my graph. I only want to show the actual dates ie the each
> fortnight in my chart
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks