Scatter Column chart ?
 

I have data organized like this:

Range Value
6-8 5
8-12 1
12-13 2
13-17 6
17-18 7
18-20 9


And I want to do a column chart with a spacing
based on the x-values (like a XY scatter graph). Note that the
intervals are not constant.

is there any ways to do that ?

Scatter Column chart ?
 

Do you mean you want the column width to be based on the X values? This page has a
few links that may be of interest:

http://peltiertech.com/Excel/ChartsH...thColumns.html

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

Euh wrote:
I have data organized like this:

Range Value
6-8 5
8-12 1
12-13 2
13-17 6
17-18 7
18-20 9


And I want to do a column chart with a spacing
based on the x-values (like a XY scatter graph). Note that the
intervals are not constant.

is there any ways to do that ?

Scatter Column chart ?
 

Hi,

Here is one example of variable width columns.
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy

Euh wrote:
I have data organized like this:

Range Value
6-8 5
8-12 1
12-13 2
13-17 6
17-18 7
18-20 9


And I want to do a column chart with a spacing
based on the x-values (like a XY scatter graph). Note that the
intervals are not constant.

is there any ways to do that ?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Scatter Column chart ?
 

Doh! I see Jon's page already provides this link.

Andy Pope wrote:
Hi,

Here is one example of variable width columns.
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy

Euh wrote:

I have data organized like this:

Range Value
6-8 5
8-12 1
12-13 2
13-17 6
17-18 7
18-20 9


And I want to do a column chart with a spacing
based on the x-values (like a XY scatter graph). Note that the
intervals are not constant.

is there any ways to do that ?



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Scatter Column chart ?
 

That's okay. I've done the same to you about five times this week.

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


Andy Pope wrote:

Doh! I see Jon's page already provides this link.

Andy Pope wrote:

Hi,

Here is one example of variable width columns.
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy

Euh wrote:

I have data organized like this:

Range Value
6-8 5
8-12 1
12-13 2
13-17 6
17-18 7
18-20 9


And I want to do a column chart with a spacing
based on the x-values (like a XY scatter graph). Note that the
intervals are not constant.

is there any ways to do that ?

Scatter Column chart ?
 

It's almost what I want...except that I want the X-axis to be based on
the value (like in a XY scatter)

Here is one example of variable width columns.
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy

Euh wrote:

I have data organized like this:

Range Value
6-8 5
8-12 1
12-13 2
13-17 6
17-18 7
18-20 9


And I want to do a column chart with a spacing
based on the x-values (like a XY scatter graph). Note that the
intervals are not constant.

is there any ways to do that ?

Scatter Column chart ?
 

"I want the X-axis to be based on the value (like in a XY scatter)"

Apparently we're not sure what this means.

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


Euh wrote:

It's almost what I want...except that I want the X-axis to be based on
the value (like in a XY scatter)


Here is one example of variable width columns.
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy

Euh wrote:


I have data organized like this:

Range Value
6-8 5
8-12 1
12-13 2
13-17 6
17-18 7
18-20 9


And I want to do a column chart with a spacing
based on the x-values (like a XY scatter graph). Note that the
intervals are not constant.

is there any ways to do that ?

Scatter Column chart ?
 

In the examples you have given, only the width of the column are taking
into account.

In my particular case, I want the data corresponding to the "6-8"
interval to be placed at the VALUES 6-8 along the x-axis (so that if
the scale was ranging from 0 to 16, it would be more or less in the
center of the graph)




"I want the X-axis to be based on the value (like in a XY scatter)"

Apparently we're not sure what this means.

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


Euh wrote:

It's almost what I want...except that I want the X-axis to be based on
the value (like in a XY scatter)


Here is one example of variable width columns.
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy

Euh wrote:


I have data organized like this:

Range Value
6-8 5
8-12 1
12-13 2
13-17 6
17-18 7
18-20 9


And I want to do a column chart with a spacing
based on the x-values (like a XY scatter graph). Note that the
intervals are not constant.

is there any ways to do that ?

Scatter Column chart ?
 

I posted this link:

http://peltiertech.com/Excel/ChartsH...thColumns.html

which linked to several web pages. This web page was one of them:

http://pubs.logicalexpressions.com/P...cle.asp?ID=508

This has examples which show what it is you're asking. It's not a native Excel
capability, you'll have to work at it a little. But it's not overwhelmingly complex.

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

Euh wrote:

In the examples you have given, only the width of the column are taking
into account.

In my particular case, I want the data corresponding to the "6-8"
interval to be placed at the VALUES 6-8 along the x-axis (so that if
the scale was ranging from 0 to 16, it would be more or less in the
center of the graph)





"I want the X-axis to be based on the value (like in a XY scatter)"

Apparently we're not sure what this means.

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


Euh wrote:


It's almost what I want...except that I want the X-axis to be based on
the value (like in a XY scatter)



Here is one example of variable width columns.
http://www.andypope.info/charts/colwidth2.htm

Cheers
Andy

Euh wrote:



I have data organized like this:

Range Value
6-8 5
8-12 1
12-13 2
13-17 6
17-18 7
18-20 9


And I want to do a column chart with a spacing
based on the x-values (like a XY scatter graph). Note that the
intervals are not constant.

is there any ways to do that ?