hi can someone please help i have created a simple graph the shows call activity but my graph is adding dates into it when i only want it to show the dates that are recorded.
please see attached
hi can someone please help i have created a simple graph the shows call activity but my graph is adding dates into it when i only want it to show the dates that are recorded.
please see attached
You can change the label format to text. See attached.
Excel appears to have defaulted to a "date axis" for the x axis, since it recognized your x data in column a as dates.
You can format the x axis as a text axis so that it treats each date as a category rather than a date.
Originally Posted by shg
Do you mean that you want it to look like the attached?
I formatted the axis as Text, rather than Date.
Hope this helps.
Pete
Thanks guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks