I need to have a bar graph with two data sets of different scales, yet when I
change one data set to an secondary axis, the two bars combine. I need them
to be sitting side by side.
thanks
I need to have a bar graph with two data sets of different scales, yet when I
change one data set to an secondary axis, the two bars combine. I need them
to be sitting side by side.
thanks
Hi,
Here is one example.
http://peltiertech.com/Excel/ChartsH...sterStack.html
Cheers
Andy
Gill wrote:
> I need to have a bar graph with two data sets of different scales, yet when I
> change one data set to an secondary axis, the two bars combine. I need them
> to be sitting side by side.
>
> thanks
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Actually, this is more likely to be helpful:
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Andy Pope wrote:
> Hi,
>
> Here is one example.
> http://peltiertech.com/Excel/ChartsH...sterStack.html
>
> Cheers
> Andy
>
> Gill wrote:
>
>> I need to have a bar graph with two data sets of different scales, yet
>> when I change one data set to an secondary axis, the two bars
>> combine. I need them to be sitting side by side.
>>
>> thanks
>
>
Thanks Jon, I couldn't see that example for looking
Jon Peltier wrote:
> Actually, this is more likely to be helpful:
>
> http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
> Andy Pope wrote:
>
>> Hi,
>>
>> Here is one example.
>> http://peltiertech.com/Excel/ChartsH...sterStack.html
>>
>> Cheers
>> Andy
>>
>> Gill wrote:
>>
>>> I need to have a bar graph with two data sets of different scales,
>>> yet when I change one data set to an secondary axis, the two bars
>>> combine. I need them to be sitting side by side.
>>>
>>> thanks
>>
>>
>>
>
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Yeah, I need a better way to navigate through all of my examples. Maybe
I could adapt the ribbon-type user interface?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Andy Pope wrote:
> Thanks Jon, I couldn't see that example for looking
>
> Jon Peltier wrote:
>
>> Actually, this is more likely to be helpful:
>>
>> http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
>>
>> - Jon
>> -------
>> Jon Peltier, Microsoft Excel MVP
>> Peltier Technical Services
>> Tutorials and Custom Solutions
>> http://PeltierTech.com/
>> _______
>>
>> Andy Pope wrote:
>>
>>> Hi,
>>>
>>> Here is one example.
>>> http://peltiertech.com/Excel/ChartsH...sterStack.html
>>>
>>> Cheers
>>> Andy
>>>
>>> Gill wrote:
>>>
>>>> I need to have a bar graph with two data sets of different scales,
>>>> yet when I change one data set to an secondary axis, the two bars
>>>> combine. I need them to be sitting side by side.
>>>>
>>>> thanks
>>>
>>>
>>>
>>>
>>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks