Prev: Select Month, get the dates
Next: sumifs multiple columns help
From: 1 of 1 1 of on 7 May 2010 13:26
I am new in Excel 2007. In Excel 97' there was an option or using special
graphs which allowed you to have dual Y-Axis. You could then graph both $ and
% values on the same graph. I am able to find the same functionality in Excel
2007.

If someone can point me in the right direction that would be helpful.

Thanks


From: Bernard Liengme on 7 May 2010 13:59
On the chart, right click one of the data series; open the Format Data
Series dialog
Go to Series Option tab and check the box "Secondary Axis"
This method also worked in older Excel versions
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"1 of 1" <1 of 1(a)discussions.microsoft.com> wrote in message
news:AD5FEB93-BAA3-452A-9D32-ECB886FF1674(a)microsoft.com...
> I am new in Excel 2007. In Excel 97' there was an option or using special
> graphs which allowed you to have dual Y-Axis. You could then graph both $
> and
> % values on the same graph. I am able to find the same functionality in
> Excel
> 2007.
>
> If someone can point me in the right direction that would be helpful.
>
> Thanks
>
>
From: trip_to_tokyo on 7 May 2010 14:00
Please check out:-

http://www.pierrefondes.com/

- item number 51 where there is a simple example of what you want.

If my comments have helped please hit Yes.

Thanks.



"1 of 1" wrote:

> I am new in Excel 2007. In Excel 97' there was an option or using special
> graphs which allowed you to have dual Y-Axis. You could then graph both $ and
> % values on the same graph. I am able to find the same functionality in Excel
> 2007.
>
> If someone can point me in the right direction that would be helpful.
>
> Thanks
>
>
 | 
Pages: 1
Prev: Select Month, get the dates
Next: sumifs multiple columns help