Chart not Plotting Hidden Rows/Columns
Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Chart not Plotting Hidden Rows/Columns

  1. September 14th, 2006 #1
    Chakri007
    Chakri007 is offline Member
    Join Date
    17th August 2006
    Posts
    27

    Chart not Plotting Hidden Rows/Columns

    Hi All,

    I am faced with a pecular problem,
    I have mapped data from Sheet1 to Sheet2 and created graphs in Sheet2 using the data.
    but when I hide the rows in Sheet2 the Graph is being cleared off.
    Can anyone please give me a solution so as to display the Graph in Sheet2 while hiding the rows in the same sheet.

    Thanks in Advance
    Sridhar R

    Please find attached the File displaying the same
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.
    Last edited by Chakri007; September 14th, 2006 at 17:35. Reason: Updated the Spread Sheet

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
  2. September 14th, 2006 #2
    Dave Hawley's Avatar
    Dave Hawley
    Dave Hawley is offline Administrator
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,624

    Re: On Hiding The Rows The Graph Is Being Cleared Off

    With the chart selected, go to Tools>Options>Chart and uncheck plot visible cells only
    Reply With Quote Reply With Quote
  3. September 14th, 2006 #3
    Chakri007
    Chakri007 is offline Member
    Join Date
    17th August 2006
    Posts
    27

    Re: Chart not Plotting Hidden Rows/Columns

    Thanks a Lot Dave for the quick reponse

    Excel Video Tutorials / Excel Dashboards Reports

    Reply With Quote Reply With Quote
« Show Insert Function Dialog Pre Set to Function | Macro To Work On Increasing/Descreasing Data »

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Rows & Columns Not Hidden When Workbook Shared
    By trebormint in forum EXCEL HELP
    Replies: 5
    Last Post: June 30th, 2012, 02:08
  2. Plot Hidden Rows On Chart
    By Laura_C in forum EXCEL HELP
    Replies: 3
    Last Post: February 12th, 2008, 07:04
  3. Remove Hidden Rows And Columns
    By Lizg in forum EXCEL HELP
    Replies: 3
    Last Post: October 25th, 2006, 19:50
  4. copy skipping hidden rows or hidden columns value
    By ilyaskazi in forum EXCEL HELP
    Replies: 4
    Last Post: February 25th, 2006, 17:13
  5. ignore hidden rows or columns during sum
    By aurobless in forum EXCEL HELP
    Replies: 5
    Last Post: April 5th, 2005, 21:28

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