[SOLVED] 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 ?

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 ?
>

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

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

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 ?
>>>
>>
>

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 ?
> >>>
> >>
> >

"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 ?
>>>>>
>>>>
>

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 ?
> >>>>>
> >>>>
> >

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 ?
>>>>>>>
>>>>>>
>