I have a client trying to create an XY scatter chart. The values for the X
axis a 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" wrote in message
...
I have a client trying to create an XY scatter chart. The values for the X
axis a 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" wrote in message
...
I have a client trying to create an XY scatter chart. The values for the X
axis a 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" wrote in message
...
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" wrote in message
...
I have a client trying to create an XY scatter chart. The values for
the X
axis a 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" wrote in message
...

I have a client trying to create an XY scatter chart. The values for the X
axis a 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" wrote in message
...

I have a client trying to create an XY scatter chart. The values for the X
axis a 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" wrote in message
...
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" wrote in message
...

I have a client trying to create an XY scatter chart. The values for
the X
axis a 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