Graphing X-Axis Issue (Office 2002)

Topic

New Reply

I have a simple graph plotting two columns of data versus the date. Column one is a list of dates while columns 2 and 3 are the percentage values. I only have data for Monday through Friday, so my graphs have a strangeness that happens on the weekend (i.e., there are 3 days between the Friday and Monday points). Is there a way to remove the discontinuity and still maintain my date values?

I know that I can remove column one, but I lose my date values. Thanks for any help you can provide!

Andy

Reply | Quote

Replies

Make the X-Axis categories and not “dates”
Right-click on chart
Chart options – Axes tab
Primary axis, Category(x) axis:
select “Category” not automatic or time-scale

The “X” will not longer be based on the dates, but only on the values actually listed in your column.

Steve

Reply | Quote

Thanks Steve! That did it. A quote for Woody – “WOPR Lounge sure beat the Paper Clip 😉

Andy

Reply | Quote

Thanks Steve! That did it. A quote for Woody – “WOPR Lounge sure beat the Paper Clip 😉

Andy

Reply | Quote

Make the X-Axis categories and not “dates”
Right-click on chart
Chart options – Axes tab
Primary axis, Category(x) axis:
select “Category” not automatic or time-scale

The “X” will not longer be based on the dates, but only on the values actually listed in your column.

Steve

Reply | Quote