I am trying to my x-axis to match my dataset. The axis is tied to a monthly
sampling event, however the events do not occur every 30 days. I want my
first point to match the first sample date, and so-on. Thanks!
I am trying to my x-axis to match my dataset. The axis is tied to a monthly
sampling event, however the events do not occur every 30 days. I want my
first point to match the first sample date, and so-on. Thanks!
Cathy,
If I'm understanding correctly, you want to change the X-axis series from
pointing at a data range that contains months to a data range that contains
the dates that match your points. To do so, click once on your chart. In
the standard toolbar, go to Chart -> Source Data -> Series Tab. At the
bottom of the Source Data dialog box there is an input where you can change
the X axis category range.
----
Regards,
John Mansfield
http://www.pdbook.com
"cathy" wrote:
> I am trying to my x-axis to match my dataset. The axis is tied to a monthly
> sampling event, however the events do not occur every 30 days. I want my
> first point to match the first sample date, and so-on. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks