+ Reply to Thread
Results 1 to 3 of 3

Problem with a Chart from data on hidden cells

  1. #1
    Registered User
    Join Date
    03-29-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2013
    Posts
    73

    Problem with a Chart from data on hidden cells

    Hi guys,

    I created a chart from a data range that I wish to hide, the problem is that the chart goes hidden also!!!! :/

    Does anyone know how to get around this issue? I know it can be done

    Any tips please!
    Attached Images Attached Images

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,427

    Re: Problem with a Chart from data on hidden cells

    1) Right click the chart and chose "Select Data".
    2) Click on "Hidden and Empty Cells".
    3) Put a tick next to "Show data in hidden rows and columns".
    4) Click "OK".

    BSB

  3. #3
    Registered User
    Join Date
    03-29-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2013
    Posts
    73

    Re: Problem with a Chart from data on hidden cells

    Super....!!!!

+ 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] Problem with Hidden Cells
    By brettball848 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-27-2015, 10:26 AM
  2. [SOLVED] Using hidden cells for chart.
    By jstawski in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-17-2013, 05:48 PM
  3. [SOLVED] Chart not showing results when cells are hidden
    By Dibbley247 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-17-2013, 10:58 AM
  4. Problem with AutoFilter and Hidden Cells
    By jacksonsoccerboy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-09-2009, 06:15 PM
  5. Replies: 4
    Last Post: 02-03-2008, 05:11 PM
  6. Pasting problem with hidden/filtered cells
    By sprocket79 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 12-17-2007, 09:22 PM
  7. Hidden data - hidden chart
    By Brisbane Rob in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-01-2006, 04:51 PM

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