+ Reply to Thread
Results 1 to 10 of 10

Excel chart and disabling cells

  1. #1
    Registered User
    Join Date
    06-12-2014
    Posts
    21

    Excel chart and disabling cells

    Hi Everybody,

    I have a question. Attached is a dummy sheet with a chart. In the sheet you will notice that there is only the chart and cells behind it are all disabled. Can you tell me how do you do it?? Looking forward to your help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Excel chart and disabling cells

    i also notice the chart has not data as the cells behind it have been deleted?

    if this is what you want then you would just setup a chart to look like how you want it and delete the sheet behind it?
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    06-12-2014
    Posts
    21

    Re: Excel chart and disabling cells

    hey i tried setting up up chart and deleting the sheets it didnt work. For example in sheet 1 I have my data. Sheet 2 has the chart in the format i wanted. In sheet 3 have the similar graph but unable to delete the cells behind or the background. How can i make sheet 3 background look like sheet 2? I have attached the dummy excel for your reference
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Excel chart and disabling cells

    so you want sheet 3 graph to look like sheet 2?

    if so

    https://support.office.com/en-ie/art...1-1d0788ea783f

  5. #5
    Registered User
    Join Date
    06-12-2014
    Posts
    21

    Re: Excel chart and disabling cells

    Hey I understand the part where I can fix the chart but I want to know how I can disable the cells in my background?

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Excel chart and disabling cells

    once in a chart sheet there is no background?
    or you talking about the data which populates it?
    is so just delink or delete it

  7. #7
    Registered User
    Join Date
    06-12-2014
    Posts
    21

    Re: Excel chart and disabling cells

    No the data that populates the hart is in a different sheet. But if u look at sheet 2 there is no cells behind the chart. the chart is the onlz thing on the sheet. Wanted to know how we can do that

  8. #8
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Excel chart and disabling cells

    i am still confused on what your after
    on your original sheet there is no data linked to chart that is why the chart appears that way
    now you are saying there is data behind the chart but you want the chart to appear that way

    with the link under the section
    Move a chart to another worksheet
    once the chart is on its own sheet the background will be disabled there would be no cells to enter into

  9. #9
    Registered User
    Join Date
    06-12-2014
    Posts
    21

    Re: Excel chart and disabling cells

    Thanks I got it now.

  10. #10
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Excel chart and disabling cells

    great, was starting to doubt myself there

    Thanks for the rep

    cheers
    Hum

+ 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. Conditional grey-out and disabling of cells
    By jman0707 in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 04-05-2021, 06:23 AM
  2. conditional disabling cells in excel?
    By I_amr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2011, 08:18 AM
  3. Disabling cells in xls
    By Blue07 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-06-2009, 05:27 PM
  4. Disabling cells in excel based on condition
    By rajendra_1510 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-08-2009, 08:03 AM
  5. [SOLVED] Disabling effects of cells (temporarily)
    By booner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-11-2005, 09:40 AM

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