software

My data comprises series of data (hours) by months for various projects (prj
1, 2 ,3 etc) My chart plots these series, and the X axis covers say, June 05
- Jun 07. In Prj# X I do have data for this entire period, but I only want
to select say Jan 06 - Jan 07 to be taken into the chart.

I have selected the correct range for Jan 06 - Jan 07 for Prj#X, however the
chart is still reflecting the entire series of data!

Obviously something's wrong somewhere, but I cannot fathom it out...any
ideas greatfully received. Thank you, all!

Allan

quot;Alquot; gt; wrote in message
...
gt; My data comprises series of data (hours) by months for various projects
gt; (prj
gt; 1, 2 ,3 etc) My chart plots these series, and the X axis covers say, June
gt; 05
gt; - Jun 07. In Prj# X I do have data for this entire period, but I only
gt; want
gt; to select say Jan 06 - Jan 07 to be taken into the chart.
gt;
gt; I have selected the correct range for Jan 06 - Jan 07 for Prj#X, however
gt; the
gt; chart is still reflecting the entire series of data!
gt;
gt; Obviously something's wrong somewhere, but I cannot fathom it out...any
gt; ideas greatfully received. Thank you, all!

Go to quot;Chart/ Source Dataquot; and see what is set for the X axis data.
--
David Biddulph
David, thanks but this doesn't seem to achieve what I need...let me try to
explain again.

I have 10 data series - prj 1,2,3...10
Each series has 36 cells - month 1,2,3,....36
My X axis is set for month 1 - 36

I now want to take up into the chart only months 24-36 for prj 8, so I
select these cells in the values range for prj 8. (If I amend the X axis when
changing the prj 8 range then the entire chart is changed to reflect only
month 24 onwards, so this is not my solution.)

What happens in my chart is that the prj 8 series does in fact start with
month 24 in the chart, but it is put into the chart in the month 1 column,
and all prj 8 data is shifted to the left! (Placing my mouse over the chart
the pop up reflects the correct quot;namesquot; of the positions in the chart but of
course the info is wrong - i.e. prj 8, month 1 has the month 24 data!)

I hope my explanation above isn't too confusing, and that you've suggestions
as to how to achieve what I need. (I have in the meanwhile quot;trickedquot; Excel by
entering zeros in the months that I do not want to show in the chart, and
simply used the full range (month1-36) for project 8! Not entirely
satisfactory, but the result is what I want. There must be a way of picking
parts of ranges to enter into a chart!?)

Allan
quot;David Biddulphquot; wrote:

gt; quot;Alquot; gt; wrote in message
gt; ...
gt; gt; My data comprises series of data (hours) by months for various projects
gt; gt; (prj
gt; gt; 1, 2 ,3 etc) My chart plots these series, and the X axis covers say, June
gt; gt; 05
gt; gt; - Jun 07. In Prj# X I do have data for this entire period, but I only
gt; gt; want
gt; gt; to select say Jan 06 - Jan 07 to be taken into the chart.
gt; gt;
gt; gt; I have selected the correct range for Jan 06 - Jan 07 for Prj#X, however
gt; gt; the
gt; gt; chart is still reflecting the entire series of data!
gt; gt;
gt; gt; Obviously something's wrong somewhere, but I cannot fathom it out...any
gt; gt; ideas greatfully received. Thank you, all!
gt;
gt; Go to quot;Chart/ Source Dataquot; and see what is set for the X axis data.
gt; --
gt; David Biddulph
gt;
gt;
gt;

quot;Alquot; gt; wrote in message
...
gt; David, thanks but this doesn't seem to achieve what I need...let me try to
gt; explain again.
gt;
gt; I have 10 data series - prj 1,2,3...10
gt; Each series has 36 cells - month 1,2,3,....36
gt; My X axis is set for month 1 - 36
gt;
gt; I now want to take up into the chart only months 24-36 for prj 8, so I
gt; select these cells in the values range for prj 8. (If I amend the X axis
gt; when
gt; changing the prj 8 range then the entire chart is changed to reflect only
gt; month 24 onwards, so this is not my solution.)
gt;
gt; What happens in my chart is that the prj 8 series does in fact start with
gt; month 24 in the chart, but it is put into the chart in the month 1 column,
gt; and all prj 8 data is shifted to the left! (Placing my mouse over the
gt; chart
gt; the pop up reflects the correct quot;namesquot; of the positions in the chart but
gt; of
gt; course the info is wrong - i.e. prj 8, month 1 has the month 24 data!)
gt;
gt; I hope my explanation above isn't too confusing, and that you've
gt; suggestions
gt; as to how to achieve what I need. (I have in the meanwhile quot;trickedquot; Excel
gt; by
gt; entering zeros in the months that I do not want to show in the chart, and
gt; simply used the full range (month1-36) for project 8! Not entirely
gt; satisfactory, but the result is what I want. There must be a way of
gt; picking
gt; parts of ranges to enter into a chart!?)

You are using XY scatter for your chart type, aren't you?
Are you saying that the cells in the X axis series contain numbers 24 to 36
but that they're being plotted as 1 to 13?
Have you checked that the month numbers really are formatted as numbers, not
text?
--
David Biddulph

gt;
gt; Allan
gt; quot;David Biddulphquot; wrote:
gt;
gt;gt; quot;Alquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; My data comprises series of data (hours) by months for various projects
gt;gt; gt; (prj
gt;gt; gt; 1, 2 ,3 etc) My chart plots these series, and the X axis covers say,
gt;gt; gt; June
gt;gt; gt; 05
gt;gt; gt; - Jun 07. In Prj# X I do have data for this entire period, but I only
gt;gt; gt; want
gt;gt; gt; to select say Jan 06 - Jan 07 to be taken into the chart.
gt;gt; gt;
gt;gt; gt; I have selected the correct range for Jan 06 - Jan 07 for Prj#X,
gt;gt; gt; however
gt;gt; gt; the
gt;gt; gt; chart is still reflecting the entire series of data!
gt;gt; gt;
gt;gt; gt; Obviously something's wrong somewhere, but I cannot fathom it out...any
gt;gt; gt; ideas greatfully received. Thank you, all!
gt;gt;
gt;gt; Go to quot;Chart/ Source Dataquot; and see what is set for the X axis data.
gt;gt; --
gt;gt; David Biddulph
gt;gt;
gt;gt;
gt;gt;
No, I think he's using a line chart. Even if you specify different category
values for series after the first, these additional series still are plotted
according to the data for series 1. There are two options:

1. Use and XY chart
2. Use a values range the same size as for the first series, and include
blanks at the beginning to offset its starting point.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;David Biddulphquot; gt; wrote in message
...
gt; quot;Alquot; gt; wrote in message
gt; ...
gt;gt; David, thanks but this doesn't seem to achieve what I need...let me try
gt;gt; to
gt;gt; explain again.
gt;gt;
gt;gt; I have 10 data series - prj 1,2,3...10
gt;gt; Each series has 36 cells - month 1,2,3,....36
gt;gt; My X axis is set for month 1 - 36
gt;gt;
gt;gt; I now want to take up into the chart only months 24-36 for prj 8, so I
gt;gt; select these cells in the values range for prj 8. (If I amend the X axis
gt;gt; when
gt;gt; changing the prj 8 range then the entire chart is changed to reflect only
gt;gt; month 24 onwards, so this is not my solution.)
gt;gt;
gt;gt; What happens in my chart is that the prj 8 series does in fact start with
gt;gt; month 24 in the chart, but it is put into the chart in the month 1
gt;gt; column,
gt;gt; and all prj 8 data is shifted to the left! (Placing my mouse over the
gt;gt; chart
gt;gt; the pop up reflects the correct quot;namesquot; of the positions in the chart but
gt;gt; of
gt;gt; course the info is wrong - i.e. prj 8, month 1 has the month 24 data!)
gt;gt;
gt;gt; I hope my explanation above isn't too confusing, and that you've
gt;gt; suggestions
gt;gt; as to how to achieve what I need. (I have in the meanwhile quot;trickedquot;
gt;gt; Excel by
gt;gt; entering zeros in the months that I do not want to show in the chart, and
gt;gt; simply used the full range (month1-36) for project 8! Not entirely
gt;gt; satisfactory, but the result is what I want. There must be a way of
gt;gt; picking
gt;gt; parts of ranges to enter into a chart!?)
gt;
gt; You are using XY scatter for your chart type, aren't you?
gt; Are you saying that the cells in the X axis series contain numbers 24 to
gt; 36 but that they're being plotted as 1 to 13?
gt; Have you checked that the month numbers really are formatted as numbers,
gt; not text?
gt; --
gt; David Biddulph
gt;
gt;gt;
gt;gt; Allan
gt;gt; quot;David Biddulphquot; wrote:
gt;gt;
gt;gt;gt; quot;Alquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt; gt; My data comprises series of data (hours) by months for various
gt;gt;gt; gt; projects
gt;gt;gt; gt; (prj
gt;gt;gt; gt; 1, 2 ,3 etc) My chart plots these series, and the X axis covers say,
gt;gt;gt; gt; June
gt;gt;gt; gt; 05
gt;gt;gt; gt; - Jun 07. In Prj# X I do have data for this entire period, but I only
gt;gt;gt; gt; want
gt;gt;gt; gt; to select say Jan 06 - Jan 07 to be taken into the chart.
gt;gt;gt; gt;
gt;gt;gt; gt; I have selected the correct range for Jan 06 - Jan 07 for Prj#X,
gt;gt;gt; gt; however
gt;gt;gt; gt; the
gt;gt;gt; gt; chart is still reflecting the entire series of data!
gt;gt;gt; gt;
gt;gt;gt; gt; Obviously something's wrong somewhere, but I cannot fathom it
gt;gt;gt; gt; out...any
gt;gt;gt; gt; ideas greatfully received. Thank you, all!
gt;gt;gt;
gt;gt;gt; Go to quot;Chart/ Source Dataquot; and see what is set for the X axis data.
gt;gt;gt; --
gt;gt;gt; David Biddulph
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;
gt;
Thanks Guys....I am using a combination of column and line charts. From my
interpretation of X-Y charts this will not work with the data I have - and
the requirements of my client - and, yes, #2 below is what I have ended up
doing to achieve my desired result. This is not ideal as every time I need
this particular chart, I'll have to blank off the data I don't want. This is
different each time, hence I'll need to resort to a quot;masterquot; rather than the
previous months version of the same chart!

Be far easier if Excel would allow me to choose a part of a series and to
take this up in the chart at the desired X axis points!

Allan

quot;Jon Peltierquot; wrote:

gt; No, I think he's using a line chart. Even if you specify different category
gt; values for series after the first, these additional series still are plotted
gt; according to the data for series 1. There are two options:
gt;
gt; 1. Use and XY chart
gt; 2. Use a values range the same size as for the first series, and include
gt; blanks at the beginning to offset its starting point.
gt;
gt; - Jon
gt; -------
gt; Jon Peltier, Microsoft Excel MVP
gt; Peltier Technical Services
gt; Tutorials and Custom Solutions
gt; PeltierTech.com/
gt; _______
gt;
gt; quot;David Biddulphquot; gt; wrote in message
gt; ...
gt; gt; quot;Alquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; David, thanks but this doesn't seem to achieve what I need...let me try
gt; gt;gt; to
gt; gt;gt; explain again.
gt; gt;gt;
gt; gt;gt; I have 10 data series - prj 1,2,3...10
gt; gt;gt; Each series has 36 cells - month 1,2,3,....36
gt; gt;gt; My X axis is set for month 1 - 36
gt; gt;gt;
gt; gt;gt; I now want to take up into the chart only months 24-36 for prj 8, so I
gt; gt;gt; select these cells in the values range for prj 8. (If I amend the X axis
gt; gt;gt; when
gt; gt;gt; changing the prj 8 range then the entire chart is changed to reflect only
gt; gt;gt; month 24 onwards, so this is not my solution.)
gt; gt;gt;
gt; gt;gt; What happens in my chart is that the prj 8 series does in fact start with
gt; gt;gt; month 24 in the chart, but it is put into the chart in the month 1
gt; gt;gt; column,
gt; gt;gt; and all prj 8 data is shifted to the left! (Placing my mouse over the
gt; gt;gt; chart
gt; gt;gt; the pop up reflects the correct quot;namesquot; of the positions in the chart but
gt; gt;gt; of
gt; gt;gt; course the info is wrong - i.e. prj 8, month 1 has the month 24 data!)
gt; gt;gt;
gt; gt;gt; I hope my explanation above isn't too confusing, and that you've
gt; gt;gt; suggestions
gt; gt;gt; as to how to achieve what I need. (I have in the meanwhile quot;trickedquot;
gt; gt;gt; Excel by
gt; gt;gt; entering zeros in the months that I do not want to show in the chart, and
gt; gt;gt; simply used the full range (month1-36) for project 8! Not entirely
gt; gt;gt; satisfactory, but the result is what I want. There must be a way of
gt; gt;gt; picking
gt; gt;gt; parts of ranges to enter into a chart!?)
gt; gt;
gt; gt; You are using XY scatter for your chart type, aren't you?
gt; gt; Are you saying that the cells in the X axis series contain numbers 24 to
gt; gt; 36 but that they're being plotted as 1 to 13?
gt; gt; Have you checked that the month numbers really are formatted as numbers,
gt; gt; not text?
gt; gt; --
gt; gt; David Biddulph
gt; gt;
gt; gt;gt;
gt; gt;gt; Allan
gt; gt;gt; quot;David Biddulphquot; wrote:
gt; gt;gt;
gt; gt;gt;gt; quot;Alquot; gt; wrote in message
gt; gt;gt;gt; ...
gt; gt;gt;gt; gt; My data comprises series of data (hours) by months for various
gt; gt;gt;gt; gt; projects
gt; gt;gt;gt; gt; (prj
gt; gt;gt;gt; gt; 1, 2 ,3 etc) My chart plots these series, and the X axis covers say,
gt; gt;gt;gt; gt; June
gt; gt;gt;gt; gt; 05
gt; gt;gt;gt; gt; - Jun 07. In Prj# X I do have data for this entire period, but I only
gt; gt;gt;gt; gt; want
gt; gt;gt;gt; gt; to select say Jan 06 - Jan 07 to be taken into the chart.
gt; gt;gt;gt; gt;
gt; gt;gt;gt; gt; I have selected the correct range for Jan 06 - Jan 07 for Prj#X,
gt; gt;gt;gt; gt; however
gt; gt;gt;gt; gt; the
gt; gt;gt;gt; gt; chart is still reflecting the entire series of data!
gt; gt;gt;gt; gt;
gt; gt;gt;gt; gt; Obviously something's wrong somewhere, but I cannot fathom it
gt; gt;gt;gt; gt; out...any
gt; gt;gt;gt; gt; ideas greatfully received. Thank you, all!
gt; gt;gt;gt;
gt; gt;gt;gt; Go to quot;Chart/ Source Dataquot; and see what is set for the X axis data.
gt; gt;gt;gt; --
gt; gt;gt;gt; David Biddulph
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;gt;gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

Instead of blanking off the data you don't want, you could set up another
column with formulas that only include data within limits you set. See how
portions of a series are included and excluded in my Conditional Charting
article:

www.peltiertech.com/Excel/Cha...nalChart1.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
PeltierTech.com
_______quot;Alquot; gt; wrote in message
...
gt; Thanks Guys....I am using a combination of column and line charts. From my
gt; interpretation of X-Y charts this will not work with the data I have - and
gt; the requirements of my client - and, yes, #2 below is what I have ended up
gt; doing to achieve my desired result. This is not ideal as every time I need
gt; this particular chart, I'll have to blank off the data I don't want. This
gt; is
gt; different each time, hence I'll need to resort to a quot;masterquot; rather than
gt; the
gt; previous months version of the same chart!
gt;
gt; Be far easier if Excel would allow me to choose a part of a series and to
gt; take this up in the chart at the desired X axis points!
gt;
gt; Allan
gt;
gt; quot;Jon Peltierquot; wrote:
gt;
gt;gt; No, I think he's using a line chart. Even if you specify different
gt;gt; category
gt;gt; values for series after the first, these additional series still are
gt;gt; plotted
gt;gt; according to the data for series 1. There are two options:
gt;gt;
gt;gt; 1. Use and XY chart
gt;gt; 2. Use a values range the same size as for the first series, and include
gt;gt; blanks at the beginning to offset its starting point.
gt;gt;
gt;gt; - Jon
gt;gt; -------
gt;gt; Jon Peltier, Microsoft Excel MVP
gt;gt; Peltier Technical Services
gt;gt; Tutorials and Custom Solutions
gt;gt; PeltierTech.com/
gt;gt; _______
gt;gt;
gt;gt; quot;David Biddulphquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; quot;Alquot; gt; wrote in message
gt;gt; gt; ...
gt;gt; gt;gt; David, thanks but this doesn't seem to achieve what I need...let me
gt;gt; gt;gt; try
gt;gt; gt;gt; to
gt;gt; gt;gt; explain again.
gt;gt; gt;gt;
gt;gt; gt;gt; I have 10 data series - prj 1,2,3...10
gt;gt; gt;gt; Each series has 36 cells - month 1,2,3,....36
gt;gt; gt;gt; My X axis is set for month 1 - 36
gt;gt; gt;gt;
gt;gt; gt;gt; I now want to take up into the chart only months 24-36 for prj 8, so I
gt;gt; gt;gt; select these cells in the values range for prj 8. (If I amend the X
gt;gt; gt;gt; axis
gt;gt; gt;gt; when
gt;gt; gt;gt; changing the prj 8 range then the entire chart is changed to reflect
gt;gt; gt;gt; only
gt;gt; gt;gt; month 24 onwards, so this is not my solution.)
gt;gt; gt;gt;
gt;gt; gt;gt; What happens in my chart is that the prj 8 series does in fact start
gt;gt; gt;gt; with
gt;gt; gt;gt; month 24 in the chart, but it is put into the chart in the month 1
gt;gt; gt;gt; column,
gt;gt; gt;gt; and all prj 8 data is shifted to the left! (Placing my mouse over the
gt;gt; gt;gt; chart
gt;gt; gt;gt; the pop up reflects the correct quot;namesquot; of the positions in the chart
gt;gt; gt;gt; but
gt;gt; gt;gt; of
gt;gt; gt;gt; course the info is wrong - i.e. prj 8, month 1 has the month 24 data!)
gt;gt; gt;gt;
gt;gt; gt;gt; I hope my explanation above isn't too confusing, and that you've
gt;gt; gt;gt; suggestions
gt;gt; gt;gt; as to how to achieve what I need. (I have in the meanwhile quot;trickedquot;
gt;gt; gt;gt; Excel by
gt;gt; gt;gt; entering zeros in the months that I do not want to show in the chart,
gt;gt; gt;gt; and
gt;gt; gt;gt; simply used the full range (month1-36) for project 8! Not entirely
gt;gt; gt;gt; satisfactory, but the result is what I want. There must be a way of
gt;gt; gt;gt; picking
gt;gt; gt;gt; parts of ranges to enter into a chart!?)
gt;gt; gt;
gt;gt; gt; You are using XY scatter for your chart type, aren't you?
gt;gt; gt; Are you saying that the cells in the X axis series contain numbers 24
gt;gt; gt; to
gt;gt; gt; 36 but that they're being plotted as 1 to 13?
gt;gt; gt; Have you checked that the month numbers really are formatted as
gt;gt; gt; numbers,
gt;gt; gt; not text?
gt;gt; gt; --
gt;gt; gt; David Biddulph
gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt; Allan
gt;gt; gt;gt; quot;David Biddulphquot; wrote:
gt;gt; gt;gt;
gt;gt; gt;gt;gt; quot;Alquot; gt; wrote in message
gt;gt; gt;gt;gt; ...
gt;gt; gt;gt;gt; gt; My data comprises series of data (hours) by months for various
gt;gt; gt;gt;gt; gt; projects
gt;gt; gt;gt;gt; gt; (prj
gt;gt; gt;gt;gt; gt; 1, 2 ,3 etc) My chart plots these series, and the X axis covers
gt;gt; gt;gt;gt; gt; say,
gt;gt; gt;gt;gt; gt; June
gt;gt; gt;gt;gt; gt; 05
gt;gt; gt;gt;gt; gt; - Jun 07. In Prj# X I do have data for this entire period, but I
gt;gt; gt;gt;gt; gt; only
gt;gt; gt;gt;gt; gt; want
gt;gt; gt;gt;gt; gt; to select say Jan 06 - Jan 07 to be taken into the chart.
gt;gt; gt;gt;gt; gt;
gt;gt; gt;gt;gt; gt; I have selected the correct range for Jan 06 - Jan 07 for Prj#X,
gt;gt; gt;gt;gt; gt; however
gt;gt; gt;gt;gt; gt; the
gt;gt; gt;gt;gt; gt; chart is still reflecting the entire series of data!
gt;gt; gt;gt;gt; gt;
gt;gt; gt;gt;gt; gt; Obviously something's wrong somewhere, but I cannot fathom it
gt;gt; gt;gt;gt; gt; out...any
gt;gt; gt;gt;gt; gt; ideas greatfully received. Thank you, all!
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt; Go to quot;Chart/ Source Dataquot; and see what is set for the X axis data.
gt;gt; gt;gt;gt; --
gt;gt; gt;gt;gt; David Biddulph
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;
gt;gt; gt;gt;gt;
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;