+ Reply to Thread
Results 1 to 3 of 3

Stops charting correct information

  1. #1
    Forum Contributor
    Join Date
    11-03-2004
    Posts
    139

    Stops charting correct information

    I have attached my file that is causing me some trouble. The chart will chart the correct information from the drop down box except for the last 5 enteries. For example, if I choose region I, it will chart the information for Raleigh. Can you please help me with finding the error. Thank you in advance for your knowledge and skill.
    Michelle
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582
    In A50, you're looking for an exact match so you need to add a ,0
    Please Login or Register  to view this content.
    You also have a few regions out of order across Row 4 (Fort Myers, Fort Smith, and Jackson). They need to be in the same order as your list in column IM.

    Does that help?

    ChemistB

  3. #3
    Forum Contributor
    Join Date
    11-03-2004
    Posts
    139
    You are a big help. It works perfectly now. Thank you so much and also for catching that my list was not in the correct order.

+ 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. moving information between sheets with macros and inputbox
    By Slaminaevil in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2008, 05:25 PM
  2. UserForm and Pasting Information
    By Sargon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-22-2008, 12:27 AM
  3. Replies: 2
    Last Post: 12-20-2007, 03:26 PM
  4. Copy information from one cell to another
    By wfufan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-18-2007, 02:51 AM
  5. how do i invert information in a column
    By Pivotrend in forum Excel General
    Replies: 6
    Last Post: 05-23-2007, 07:16 AM

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