+ Reply to Thread
Results 1 to 4 of 4
  1. 11-04-2009, 07:46 PM #1
    josh13x
    josh13x is offline
    Registered User
    Join Date
    11-03-2009
    Location
    Oklahoma City
    MS-Off Ver
    Excel 2007
    Posts
    8

    Make a Chart Floating

    I'm using autofilter in my worksheet; When i filter it hides rows. I'm trying to use a bar graph to display the totals and what not. When i filter, the chart changes sizes and what not. Anyone know how to make the chart a dedicated float chart so that it does not move?
    Reply With Quote Reply With Quote
  2. 11-04-2009, 08:11 PM #2
    shg
    shg is online now
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,132

    Re: Make a Chart Floating

    Right-click the chart > Format Chart Area > Properties tab, tick Don't move or size with cells
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate
    Reply With Quote Reply With Quote
  3. 11-04-2009, 08:16 PM #3
    josh13x
    josh13x is offline
    Registered User
    Join Date
    11-03-2009
    Location
    Oklahoma City
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Make a Chart Floating

    i'm using excel 2007 i don't see a properties tab
    Reply With Quote Reply With Quote
  4. 11-04-2009, 08:50 PM #4
    shg
    shg is online now
    Forum Moderator shg's Avatar
    Join Date
    06-21-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007
    Posts
    25,132

    Re: Make a Chart Floating

    Select the chart, click the Chart Tools Format tab, click the button for the Size dialog, Properties tab, ...
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate
    Reply With Quote Reply With Quote
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.2.0