I'm not sure I understand the question correct. See if this solution will help:
You can set the second metric to be displayed as a secondary axis. In other words. The first metric will be on the primary vertical axis on the left and teh second metric will be on the secondary vertical axis on the right. You can do this by selecting the series on the chart and then goto its format settings. In there you are able to set it to secondary axis. See here for detailed instructions: http://office.microsoft.com/en-us/excel-help/add-or-remove-a-secondary-axis-in-a-chart-HP001234165.aspx On Feb 10, 7:01 am, MikeMikeMike <michael.lovel...@gmail.com> wrote: > Greetings, > > I have a question I am hoping to find the answer of here... > > I have a spreadsheet that signifies that includes revenue which is > represented on my pivot charts as bars represented by a month (a good > example but I could come up with others of course). Simple enough > right? Well what if I have another metric that I am wanting to track > that is a drastically different number (average product cost to > customer) that I want to have on the same chart with that number > formatted as currency looking all nice and professional. > > How do I do it? > > Anyone that helps gets 1,000 thank yous on top of the 1,000 I am > giving to all who read this far ;-) > > 1,000 Thank you's to you all! > > -Michael -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
