How to draw a Chart with values on both axis

SANJAY · External Since: May 31, 2007 Posts: 3

Please let me know how I can draw a Chart in Power Point where I have
Turnover on X-Axis & Margin on Y axis for multiple product groups For
example If my total turnover is 100m, 20 mn coming from Products with margin
of 40%, 30 mn coming from Services with margin of 30% and 50 mn coming from
contracting with margin of 10%, I want the first bar on the chart to be 20 X
40, second bar to be 30 x 30 and third bar to be 50 X 10

lizliz · External Since: Oct 29, 2009 Posts: 1

First draw it in Excel and then copy it. I think that's the easiest way...

"SANJAY" wrote:

> Please let me know how I can draw a Chart in Power Point where I have
> Turnover on X-Axis & Margin on Y axis for multiple product groups For
> example If my total turnover is 100m, 20 mn coming from Products with margin
> of 40%, 30 mn coming from Services with margin of 30% and 50 mn coming from
> contracting with margin of 10%, I want the first bar on the chart to be 20 X
> 40, second bar to be 30 x 30 and third bar to be 50 X 10
>

Echo S · External Since: Jan 06, 2006 Posts: 2479

You have to use dummy data series to move the data over.

See http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx

"SANJAY" <SANJAY RemoveThis @discussions.microsoft.com> wrote in message
news:70323BCE-14EF-41C0-8B29-1D0990B256F7@microsoft.com...
> Please let me know how I can draw a Chart in Power Point where I have
> Turnover on X-Axis & Margin on Y axis for multiple product groups For
> example If my total turnover is 100m, 20 mn coming from Products with
> margin
> of 40%, 30 mn coming from Services with margin of 30% and 50 mn coming
> from
> contracting with margin of 10%, I want the first bar on the chart to be 20
> X
> 40, second bar to be 30 x 30 and third bar to be 50 X 10
>