Thread: xy scatter x axis

I have a client trying to create an XY scatter chart. The values for the X
axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are numbers,
not text. He would like these values to be displayed in relation to the
amount between the different values. For example, 16000 and 8000 should have
more space between them than 250 and 125. Is there a way to do this?
--
maryj

I wonder if he's trying to create a LINE chart rather than an XY Scatter
chart.

Barb Reinhardt

"maryj" <maryj@discussions.microsoft.com> wrote in message
news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
> I have a client trying to create an XY scatter chart. The values for the X
> axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are
numbers,
> not text. He would like these values to be displayed in relation to the
> amount between the different values. For example, 16000 and 8000 should
have
> more space between them than 250 and 125. Is there a way to do this?
> --
> maryj

We've been going back and forth between the XY and Line. It seems like he can
get part of what he wants with each of them but neither give him all that he
wants. I'm beginning to think that it can't be done, but just wanted to pick
the brains of all you charting gurus.

"Barb Reinhardt" wrote:

> I wonder if he's trying to create a LINE chart rather than an XY Scatter
> chart.
>
> Barb Reinhardt
>
> "maryj" <maryj@discussions.microsoft.com> wrote in message
> news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
> > I have a client trying to create an XY scatter chart. The values for the X
> > axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are
> numbers,
> > not text. He would like these values to be displayed in relation to the
> > amount between the different values. For example, 16000 and 8000 should
> have
> > more space between them than 250 and 125. Is there a way to do this?
> > --
> > maryj
>
>
>

What else does he want?

"maryj" <maryj@discussions.microsoft.com> wrote in message
news:6548720E-D61C-4EBE-920F-D5ACE04B15A0@microsoft.com...
> We've been going back and forth between the XY and Line. It seems like he
can
> get part of what he wants with each of them but neither give him all that
he
> wants. I'm beginning to think that it can't be done, but just wanted to
pick
> the brains of all you charting gurus.
>
> "Barb Reinhardt" wrote:
>
> > I wonder if he's trying to create a LINE chart rather than an XY Scatter
> > chart.
> >
> > Barb Reinhardt
> >
> > "maryj" <maryj@discussions.microsoft.com> wrote in message
> > news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
> > > I have a client trying to create an XY scatter chart. The values for
the X
> > > axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are
> > numbers,
> > > not text. He would like these values to be displayed in relation to
the
> > > amount between the different values. For example, 16000 and 8000
should
> > have
> > > more space between them than 250 and 125. Is there a way to do this?
> > > --
> > > maryj
> >
> >
> >

Mary -

What part of it can't he get with a scatter chart? You can format the
series to look like a line chart series by selecting the option with
connecting lines, or by double clicking the series to reformat it.

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

maryj wrote:

> We've been going back and forth between the XY and Line. It seems like he can
> get part of what he wants with each of them but neither give him all that he
> wants. I'm beginning to think that it can't be done, but just wanted to pick
> the brains of all you charting gurus.
>
> "Barb Reinhardt" wrote:
>
>
>>I wonder if he's trying to create a LINE chart rather than an XY Scatter
>>chart.
>>
>>Barb Reinhardt
>>
>>"maryj" <maryj@discussions.microsoft.com> wrote in message
>>news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
>>
>>>I have a client trying to create an XY scatter chart. The values for the X
>>>axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are
>>
>>numbers,
>>
>>>not text. He would like these values to be displayed in relation to the
>>>amount between the different values. For example, 16000 and 8000 should
>>
>>have
>>
>>>more space between them than 250 and 125. Is there a way to do this?
>>>--
>>>maryj
>>
>>
>>

The part he doesn't get is the spacing between the values on the x axis.
Since there is a larger decrease from 16000 to 8000 than between 250 and 125,
he would like the values 250 and 125 to appear closer together on the x axis
than 16000 and 8000 appear.

"Jon Peltier" wrote:

> Mary -
>
> What part of it can't he get with a scatter chart? You can format the
> series to look like a line chart series by selecting the option with
> connecting lines, or by double clicking the series to reformat it.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> maryj wrote:
>
> > We've been going back and forth between the XY and Line. It seems like he can
> > get part of what he wants with each of them but neither give him all that he
> > wants. I'm beginning to think that it can't be done, but just wanted to pick
> > the brains of all you charting gurus.
> >
> > "Barb Reinhardt" wrote:
> >
> >
> >>I wonder if he's trying to create a LINE chart rather than an XY Scatter
> >>chart.
> >>
> >>Barb Reinhardt
> >>
> >>"maryj" <maryj@discussions.microsoft.com> wrote in message
> >>news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
> >>
> >>>I have a client trying to create an XY scatter chart. The values for the X
> >>>axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are
> >>
> >>numbers,
> >>
> >>>not text. He would like these values to be displayed in relation to the
> >>>amount between the different values. For example, 16000 and 8000 should
> >>
> >>have
> >>
> >>>more space between them than 250 and 125. Is there a way to do this?
> >>>--
> >>>maryj
> >>
> >>
> >>
>

I guess I'm confused. With an XY Scatter chart, you can get this. Are
each individual X value you listed the same distance apart now? If they
are, it's probably set up as a LINE chart.


"maryj" <maryj@discussions.microsoft.com> wrote in message
news:E95C0384-2820-4C76-907E-D77F429D4C32@microsoft.com...
> The part he doesn't get is the spacing between the values on the x axis.
> Since there is a larger decrease from 16000 to 8000 than between 250 and
125,
> he would like the values 250 and 125 to appear closer together on the x
axis
> than 16000 and 8000 appear.
>
> "Jon Peltier" wrote:
>
> > Mary -
> >
> > What part of it can't he get with a scatter chart? You can format the
> > series to look like a line chart series by selecting the option with
> > connecting lines, or by double clicking the series to reformat it.
> >
> > - Jon
> > -------
> > Jon Peltier, Microsoft Excel MVP
> > Peltier Technical Services
> > Tutorials and Custom Solutions
> > http://PeltierTech.com/
> > _______
> >
> > maryj wrote:
> >
> > > We've been going back and forth between the XY and Line. It seems like
he can
> > > get part of what he wants with each of them but neither give him all
that he
> > > wants. I'm beginning to think that it can't be done, but just wanted
to pick
> > > the brains of all you charting gurus.
> > >
> > > "Barb Reinhardt" wrote:
> > >
> > >
> > >>I wonder if he's trying to create a LINE chart rather than an XY
Scatter
> > >>chart.
> > >>
> > >>Barb Reinhardt
> > >>
> > >>"maryj" <maryj@discussions.microsoft.com> wrote in message
> > >>news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
> > >>
> > >>>I have a client trying to create an XY scatter chart. The values for
the X
> > >>>axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are
> > >>
> > >>numbers,
> > >>
> > >>>not text. He would like these values to be displayed in relation to
the
> > >>>amount between the different values. For example, 16000 and 8000
should
> > >>
> > >>have
> > >>
> > >>>more space between them than 250 and 125. Is there a way to do this?
> > >>>--
> > >>>maryj
> > >>
> > >>
> > >>
> >

I guess I'm confusing myself, too It is an XY Scatter. The data source
identifies the correct range to be used for the X axis, but the labels for
the x axis, shows different numbers, ie. 0, 5000, etc. He wants the same
values to display as the X axis labels as the values in the data range -
16000, 8000, etc. Using a Line chart, he gets the x axis labels he wants, but
not, as you mentioned, the correct interval spacing. The XY chart, gives the
interval spacing but not the correct x axis labels. Hope that makes sense.

"Barb Reinhardt" wrote:

> I guess I'm confused. With an XY Scatter chart, you can get this. Are
> each individual X value you listed the same distance apart now? If they
> are, it's probably set up as a LINE chart.
>
>
> "maryj" <maryj@discussions.microsoft.com> wrote in message
> news:E95C0384-2820-4C76-907E-D77F429D4C32@microsoft.com...
> > The part he doesn't get is the spacing between the values on the x axis.
> > Since there is a larger decrease from 16000 to 8000 than between 250 and
> 125,
> > he would like the values 250 and 125 to appear closer together on the x
> axis
> > than 16000 and 8000 appear.
> >
> > "Jon Peltier" wrote:
> >
> > > Mary -
> > >
> > > What part of it can't he get with a scatter chart? You can format the
> > > series to look like a line chart series by selecting the option with
> > > connecting lines, or by double clicking the series to reformat it.
> > >
> > > - Jon
> > > -------
> > > Jon Peltier, Microsoft Excel MVP
> > > Peltier Technical Services
> > > Tutorials and Custom Solutions
> > > http://PeltierTech.com/
> > > _______
> > >
> > > maryj wrote:
> > >
> > > > We've been going back and forth between the XY and Line. It seems like
> he can
> > > > get part of what he wants with each of them but neither give him all
> that he
> > > > wants. I'm beginning to think that it can't be done, but just wanted
> to pick
> > > > the brains of all you charting gurus.
> > > >
> > > > "Barb Reinhardt" wrote:
> > > >
> > > >
> > > >>I wonder if he's trying to create a LINE chart rather than an XY
> Scatter
> > > >>chart.
> > > >>
> > > >>Barb Reinhardt
> > > >>
> > > >>"maryj" <maryj@discussions.microsoft.com> wrote in message
> > > >>news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
> > > >>
> > > >>>I have a client trying to create an XY scatter chart. The values for
> the X
> > > >>>axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are
> > > >>
> > > >>numbers,
> > > >>
> > > >>>not text. He would like these values to be displayed in relation to
> the
> > > >>>amount between the different values. For example, 16000 and 8000
> should
> > > >>
> > > >>have
> > > >>
> > > >>>more space between them than 250 and 125. Is there a way to do this?
> > > >>>--
> > > >>>maryj
> > > >>
> > > >>
> > > >>
> > >
>
>
>

You might want to check the data series to see what you have defined for the
X and Y axes. You should get what you want using the XY chart.

"maryj" <maryj@discussions.microsoft.com> wrote in message
news:B0F90F0F-A321-4242-81CE-CF83EC661C25@microsoft.com...
> I guess I'm confusing myself, too It is an XY Scatter. The data source
> identifies the correct range to be used for the X axis, but the labels for
> the x axis, shows different numbers, ie. 0, 5000, etc. He wants the same
> values to display as the X axis labels as the values in the data range -
> 16000, 8000, etc. Using a Line chart, he gets the x axis labels he wants,
but
> not, as you mentioned, the correct interval spacing. The XY chart, gives
the
> interval spacing but not the correct x axis labels. Hope that makes sense.
>
> "Barb Reinhardt" wrote:
>
> > I guess I'm confused. With an XY Scatter chart, you can get this.
Are
> > each individual X value you listed the same distance apart now? If they
> > are, it's probably set up as a LINE chart.
> >
> >
> > "maryj" <maryj@discussions.microsoft.com> wrote in message
> > news:E95C0384-2820-4C76-907E-D77F429D4C32@microsoft.com...
> > > The part he doesn't get is the spacing between the values on the x
axis.
> > > Since there is a larger decrease from 16000 to 8000 than between 250
and
> > 125,
> > > he would like the values 250 and 125 to appear closer together on the
x
> > axis
> > > than 16000 and 8000 appear.
> > >
> > > "Jon Peltier" wrote:
> > >
> > > > Mary -
> > > >
> > > > What part of it can't he get with a scatter chart? You can format
the
> > > > series to look like a line chart series by selecting the option with
> > > > connecting lines, or by double clicking the series to reformat it.
> > > >
> > > > - Jon
> > > > -------
> > > > Jon Peltier, Microsoft Excel MVP
> > > > Peltier Technical Services
> > > > Tutorials and Custom Solutions
> > > > http://PeltierTech.com/
> > > > _______
> > > >
> > > > maryj wrote:
> > > >
> > > > > We've been going back and forth between the XY and Line. It seems
like
> > he can
> > > > > get part of what he wants with each of them but neither give him
all
> > that he
> > > > > wants. I'm beginning to think that it can't be done, but just
wanted
> > to pick
> > > > > the brains of all you charting gurus.
> > > > >
> > > > > "Barb Reinhardt" wrote:
> > > > >
> > > > >
> > > > >>I wonder if he's trying to create a LINE chart rather than an XY
> > Scatter
> > > > >>chart.
> > > > >>
> > > > >>Barb Reinhardt
> > > > >>
> > > > >>"maryj" <maryj@discussions.microsoft.com> wrote in message
> > > > >>news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
> > > > >>
> > > > >>>I have a client trying to create an XY scatter chart. The values
for
> > the X
> > > > >>>axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They
are
> > > > >>
> > > > >>numbers,
> > > > >>
> > > > >>>not text. He would like these values to be displayed in relation
to
> > the
> > > > >>>amount between the different values. For example, 16000 and 8000
> > should
> > > > >>
> > > > >>have
> > > > >>
> > > > >>>more space between them than 250 and 125. Is there a way to do
this?
> > > > >>>--
> > > > >>>maryj
> > > > >>
> > > > >>
> > > > >>
> > > >
> >
> >
> >

Stay with the XY Scatter chart. Create a 2nd series that has the same
x-values as the original data and zeros for the y-values. Remove the
x-axis data labels. For this dummy series show the data labels (x
values only). Position the labels to be below the series.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <B0F90F0F-A321-4242-81CE-CF83EC661C25@microsoft.com>,
maryj@discussions.microsoft.com says...
> I guess I'm confusing myself, too It is an XY Scatter. The data source
> identifies the correct range to be used for the X axis, but the labels for
> the x axis, shows different numbers, ie. 0, 5000, etc. He wants the same
> values to display as the X axis labels as the values in the data range -
> 16000, 8000, etc. Using a Line chart, he gets the x axis labels he wants, but
> not, as you mentioned, the correct interval spacing. The XY chart, gives the
> interval spacing but not the correct x axis labels. Hope that makes sense.
>
> "Barb Reinhardt" wrote:
>
> > I guess I'm confused. With an XY Scatter chart, you can get this. Are
> > each individual X value you listed the same distance apart now? If they
> > are, it's probably set up as a LINE chart.
> >
> >
> > "maryj" <maryj@discussions.microsoft.com> wrote in message
> > news:E95C0384-2820-4C76-907E-D77F429D4C32@microsoft.com...
> > > The part he doesn't get is the spacing between the values on the x axis.
> > > Since there is a larger decrease from 16000 to 8000 than between 250 and
> > 125,
> > > he would like the values 250 and 125 to appear closer together on the x
> > axis
> > > than 16000 and 8000 appear.
> > >
> > > "Jon Peltier" wrote:
> > >
> > > > Mary -
> > > >
> > > > What part of it can't he get with a scatter chart? You can format the
> > > > series to look like a line chart series by selecting the option with
> > > > connecting lines, or by double clicking the series to reformat it.
> > > >
> > > > - Jon
> > > > -------
> > > > Jon Peltier, Microsoft Excel MVP
> > > > Peltier Technical Services
> > > > Tutorials and Custom Solutions
> > > > http://PeltierTech.com/
> > > > _______
> > > >
> > > > maryj wrote:
> > > >
> > > > > We've been going back and forth between the XY and Line. It seems like
> > he can
> > > > > get part of what he wants with each of them but neither give him all
> > that he
> > > > > wants. I'm beginning to think that it can't be done, but just wanted
> > to pick
> > > > > the brains of all you charting gurus.
> > > > >
> > > > > "Barb Reinhardt" wrote:
> > > > >
> > > > >
> > > > >>I wonder if he's trying to create a LINE chart rather than an XY
> > Scatter
> > > > >>chart.
> > > > >>
> > > > >>Barb Reinhardt
> > > > >>
> > > > >>"maryj" <maryj@discussions.microsoft.com> wrote in message
> > > > >>news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
> > > > >>
> > > > >>>I have a client trying to create an XY scatter chart. The values for
> > the X
> > > > >>>axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are
> > > > >>
> > > > >>numbers,
> > > > >>
> > > > >>>not text. He would like these values to be displayed in relation to
> > the
> > > > >>>amount between the different values. For example, 16000 and 8000
> > should
> > > > >>
> > > > >>have
> > > > >>
> > > > >>>more space between them than 250 and 125. Is there a way to do this?
> > > > >>>--
> > > > >>>maryj
> > > > >>
> > > > >>
> > > > >>
> > > >
> >
> >
> >
>

Maryj,

If it helps, I will post a detailed example of the solution that Tushar is
referring to on my website after I get home from work tonight. As Jon, Barb,
and Tushar mentioned the XY Scatter chart should work for you. The URL is
below.

----
Regards,
John Mansfield
http://www.pdbook.com

"maryj" wrote:

> I guess I'm confusing myself, too It is an XY Scatter. The data source
> identifies the correct range to be used for the X axis, but the labels for
> the x axis, shows different numbers, ie. 0, 5000, etc. He wants the same
> values to display as the X axis labels as the values in the data range -
> 16000, 8000, etc. Using a Line chart, he gets the x axis labels he wants, but
> not, as you mentioned, the correct interval spacing. The XY chart, gives the
> interval spacing but not the correct x axis labels. Hope that makes sense.
>
> "Barb Reinhardt" wrote:
>
> > I guess I'm confused. With an XY Scatter chart, you can get this. Are
> > each individual X value you listed the same distance apart now? If they
> > are, it's probably set up as a LINE chart.
> >
> >
> > "maryj" <maryj@discussions.microsoft.com> wrote in message
> > news:E95C0384-2820-4C76-907E-D77F429D4C32@microsoft.com...
> > > The part he doesn't get is the spacing between the values on the x axis.
> > > Since there is a larger decrease from 16000 to 8000 than between 250 and
> > 125,
> > > he would like the values 250 and 125 to appear closer together on the x
> > axis
> > > than 16000 and 8000 appear.
> > >
> > > "Jon Peltier" wrote:
> > >
> > > > Mary -
> > > >
> > > > What part of it can't he get with a scatter chart? You can format the
> > > > series to look like a line chart series by selecting the option with
> > > > connecting lines, or by double clicking the series to reformat it.
> > > >
> > > > - Jon
> > > > -------
> > > > Jon Peltier, Microsoft Excel MVP
> > > > Peltier Technical Services
> > > > Tutorials and Custom Solutions
> > > > http://PeltierTech.com/
> > > > _______
> > > >
> > > > maryj wrote:
> > > >
> > > > > We've been going back and forth between the XY and Line. It seems like
> > he can
> > > > > get part of what he wants with each of them but neither give him all
> > that he
> > > > > wants. I'm beginning to think that it can't be done, but just wanted
> > to pick
> > > > > the brains of all you charting gurus.
> > > > >
> > > > > "Barb Reinhardt" wrote:
> > > > >
> > > > >
> > > > >>I wonder if he's trying to create a LINE chart rather than an XY
> > Scatter
> > > > >>chart.
> > > > >>
> > > > >>Barb Reinhardt
> > > > >>
> > > > >>"maryj" <maryj@discussions.microsoft.com> wrote in message
> > > > >>news:6135E8A7-30CC-4C5A-9B6B-5FCCD0D80E70@microsoft.com...
> > > > >>
> > > > >>>I have a client trying to create an XY scatter chart. The values for
> > the X
> > > > >>>axis are: 16000, 8000, 4000, 2000, 1000, 500, 250 and 125. They are
> > > > >>
> > > > >>numbers,
> > > > >>
> > > > >>>not text. He would like these values to be displayed in relation to
> > the
> > > > >>>amount between the different values. For example, 16000 and 8000
> > should
> > > > >>
> > > > >>have
> > > > >>
> > > > >>>more space between them than 250 and 125. Is there a way to do this?
> > > > >>>--
> > > > >>>maryj
> > > > >>
> > > > >>
> > > > >>
> > > >
> >
> >
> >