+ Reply to Thread
Results 1 to 2 of 2

Rotate charts without pivoting the data

Hybrid View

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    Reston, VA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Rotate charts without pivoting the data

    I have a combination chart that I'm creating. The chart is a copy of how the data is formatted by a vendor. We own the data and I need to recreate the charts identically to the way the vendor presents it. This chart requires that I use a bar chart with a scatter chart. However, since the bar chart plots the data horizontally and scatter chart plots vertically, I'm not able to use these two charts togeher. Alternatively, I can use a column chart and then turn it into an image and rotate the image so the data is presented the way I need it, but I have approximately 90 charts to create and this would be time consuming. I've looked to see if I can rotate the chart directly in Excel, but it appears the only chart that you can do this with is a pie chart. Is there anything that can be done in Excel that will allow me to do this?

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Rotate charts without pivoting the data

    The only reason for not being able to do a bar/ xyscatter combination is that the bar is in 3d.

    If you need more help you will need to post an EXAMPLE workbook with the data layout you have and an example of the required chart.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1