A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

connecting lines when using empty columns



 
 
Thread Tools Display Modes
  #1  
Old October 13th, 2003, 11:22 PM
heather p.
external usenet poster
 
Posts: n/a
Default connecting lines when using empty columns

Hello,

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.

TIA!
  #2  
Old October 14th, 2003, 12:21 PM
Jerry W. Lewis
external usenet poster
 
Posts: n/a
Default connecting lines when using empty columns

Use #N/A or NA() in the empty cells

Jerry

heather p. wrote:

Hello,

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.

TIA!


  #3  
Old October 14th, 2003, 04:07 PM
dvt
external usenet poster
 
Posts: n/a
Default connecting lines when using empty columns

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
  #4  
Old October 14th, 2003, 05:15 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default connecting lines when using empty columns

Heather -

If you enter the data on the first or last day of each four or five week
period, and retain a Line chart, you can still spread out the data
according to the length of each month, in days. Right click the chart,
pick Chart Options from the pop up menu, click on the Axes tab, and
select Time Scale. Double click on the time scale axis, and click on
the Scale tab. Change Base Unit to Day(s), and format the other
parameters as you need them.

The difference between 30 and 31 day months is not remarkable if you
show an entire year, but I suspect you could tell a 28 day month from a
35 day month with one eye closed.

If not for the axis scaling features of a time scale axis, I'd use
Dave's XY Scatter chart suggestion.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

dvt wrote:
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
that 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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.