+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    11-22-2008
    Location
    house
    Posts
    68

    Data Validation box on Chart Sheet

    Hi there,

    I have created several Data Validation boxes to help me populate a chart however they are currently located on another sheet. Is there anyway I can place the boxes on the actual chart sheet? I tried a simple copy and paste however this only works with regular worksheets (not chart sheets)

    An option would be to place the chart within a normal sheet however I would prefer to not do this.

    Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944

    Re: Data Validation box on Chart Sheet

    Not if the data validation is of the cell type. As it requries a cell to hold the information.

    If the validation is actually a dropdown control then you can use controls from the Forms toolbar on a chart sheet.
    Cheers
    Andy
    www.andypope.info

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

Search Engine Friendly URLs by vBSEO 3.2.0