+ Reply to Thread
Results 1 to 2 of 2

Legend overlaps a complex Scatter Chart

  1. #1
    Registered User
    Join Date
    01-16-2013
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Legend overlaps a complex Scatter Chart

    Currently, I have a scatter chart that has 2 sets of series data. I have added in arrows and chart titles and have grouped all the items together so that when I change the size of the chart, everything expands together. I decided to insert a legend to the right of my chart. There is no room to the right of the chart. I know how to insert a legend to the right, but it overlaps the chart. I even have the "Show legend without overlapping the chart" box checked but it still overlaps onto the chart. I think it overlaps because my chart has a secondary axis with data and items that are grouped together. I cannot expand the size of the chart area without the entire chart expanding along with it. How do I expand the chart area without my chart getting larger so that I can move my legend into this blank space?

    Thanks!
    Micah

  2. #2
    Registered User
    Join Date
    01-16-2013
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Legend overlaps a complex Scatter Chart

    A friend found the solution!

    Because the chartobject is grouped with shapes you have to do the following to explicit change the chart.
    Click the shape, notice the contextual tab is Drawing Tools.
    Click the chart within the grouped shapes, notice contextual tab is Chart Tools.
    Use the Format tab > Current Selection. In the drop down box select Plot area. You can now use the sizing handles to move and or resize plot area.

    Thanks, Andy!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Scatter Plot, with legend?
    By dpsersimon in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-02-2013, 09:33 PM
  2. [SOLVED] Complex scatter chart
    By Mtes in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-03-2012, 03:52 AM
  3. [SOLVED] Exclude one data series from scatter chart legend (but not from the chart)
    By JayUSA in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-29-2012, 05:24 PM
  4. Excel 2007 : bar chart - series name overlaps data
    By Cashew in forum Excel General
    Replies: 0
    Last Post: 08-28-2010, 03:50 PM
  5. scatter plot colors/legend
    By liquidspaces in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-25-2008, 08:10 PM

Tags for this Thread

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