Prev: Pivot table & chart problem, How to show different subtotal levels
Next: Excel line chart
From: NM on 9 Mar 2010 09:04
A+B= x

I want to show:
-In one stacked column, I want to show (A+B) and in the same chart in a line
form I want to show how much percentage is B.

How can I do this?

Thanks!
From: Luke M on 9 Mar 2010 10:12
You will need to create another series that uses formulas to calculate the
percentage, and then add that to your chart. You can create a combination
chart by selecting the new series, then going to Chart - Chart Type, line.

--
Best Regards,

Luke M
"NM" <NM(a)discussions.microsoft.com> wrote in message
news:5F31E875-262E-4055-BBB1-A357B4D712A3(a)microsoft.com...
> A+B= x
>
> I want to show:
> -In one stacked column, I want to show (A+B) and in the same chart in a
> line
> form I want to show how much percentage is B.
>
> How can I do this?
>
> Thanks!


From: NM on 9 Mar 2010 12:32
Hi Luke,

I have created a column which has formulas to calculate percentages. But how
do I enter this data into the existing column chart ( columns show numbers).
I right clicked in the chart area >select data> Add new series. But its not
showing up. Can you please tell me step wise how can I get the percentage
line in the same chart with columns showing numbers.

Thanks much!

"Luke M" wrote:

> You will need to create another series that uses formulas to calculate the
> percentage, and then add that to your chart. You can create a combination
> chart by selecting the new series, then going to Chart - Chart Type, line.
>
> --
> Best Regards,
>
> Luke M
> "NM" <NM(a)discussions.microsoft.com> wrote in message
> news:5F31E875-262E-4055-BBB1-A357B4D712A3(a)microsoft.com...
> > A+B= x
> >
> > I want to show:
> > -In one stacked column, I want to show (A+B) and in the same chart in a
> > line
> > form I want to show how much percentage is B.
> >
> > How can I do this?
> >
> > Thanks!
>
>
> .
>
From: AdamV on 12 Mar 2010 08:31
When you did "Add new series" and it does not show up, is it still
visible in the Select data box?
Is it just not showing up because the % firgures are tiny compared to
the actual figures (eg % is <100 in your case, and you may have money
values in millions or billions)?

Sounds like it could be there but just too small to see.
Go to the Chart Tools|Layout ribbon, at the left hand end in the drop
down list see if your new series is there. If it is, choose it in the
list. Beneath that list is a button to format the selection, click that
and in the format series dialogue box click to plot this on a secondary
axis. (this is to deal with the scaling problem, not the chart type).
Close the format dialogue.
Now go to the Design ribbon and click on "Change chart type" at the left
while this series is still selected. Choose a line chart or whatever is
appropriate for you.

Hope this helps
Adam

On 09/03/2010 17:32, NM wrote:
> Hi Luke,
>
> I have created a column which has formulas to calculate percentages. But how
> do I enter this data into the existing column chart ( columns show numbers).
> I right clicked in the chart area>select data> Add new series. But its not
> showing up. Can you please tell me step wise how can I get the percentage
> line in the same chart with columns showing numbers.
>
> Thanks much!
>
> "Luke M" wrote:
>
>> You will need to create another series that uses formulas to calculate the
>> percentage, and then add that to your chart. You can create a combination
>> chart by selecting the new series, then going to Chart - Chart Type, line.
>>
>> --
>> Best Regards,
>>
>> Luke M
>> "NM"<NM(a)discussions.microsoft.com> wrote in message
>> news:5F31E875-262E-4055-BBB1-A357B4D712A3(a)microsoft.com...
>>> A+B= x
>>>
>>> I want to show:
>>> -In one stacked column, I want to show (A+B) and in the same chart in a
>>> line
>>> form I want to show how much percentage is B.
>>>
>>> How can I do this?
>>>
>>> Thanks!
>>
>>
>> .
>>
 | 
Pages: 1
Prev: Pivot table & chart problem, How to show different subtotal levels
Next: Excel line chart