heather p. wrote:
I trying to create a trend chart (line chart) that shows
monthly data. The data has been rolled so some months
have four weeks of data combined and others have 5 weeks.
I'm trying to find a way to make the space between the
monthly data points reflect the number of weeks in the
month. I put empty columns between the monthly data
points to get the needed spacing, but lost the line to
connect them. If I take out the empty columns then the
months are spaced equally.


Sounds like the perfect application for an XY scatter chart rather than =
a =

line chart. In a nutshell, each data point has an additional number tha=
t =

determines where on the x-axis the point is charted. I know that =

one-sentence descriptions are rarely helpful, so I suggest the help =

function to describe the XY scatter chart in more detail.

-- =

Dave
dvt at psu dot edu