+ Reply to Thread
Results 1 to 2 of 2

Hard-coded Chart Series names show up blank until I paste data?

  1. #1
    Registered User
    Join Date
    04-14-2010
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    24

    Hard-coded Chart Series names show up blank until I paste data?

    Hi,
    In Excel 2010, I have a Data worksheet and a Charts worksheet. In the Charts worksheet I have hard-coded series names in the charts, while the x/y axes refer to named ranges in the Data sheet.

    When there is no data in the sheet, I expect to at least see the hard-coded Series Names in the Charts, but they are blank.

    Right-Clicking on the chart, and choosing "Select Data" shows "Blank Series" for all the series in the chart.

    This behavior was not present in Excel 2007, but suddenly is behaving this way in Excel 2010. (The sheets are actually .xls sheets created in Excel 2003, and they must stay in that format due to user base with these three versions of Excel).

    Thanks for any insight on this,
    --Jim

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Hard-coded Chart Series names show up blank until I paste data?

    Can you post example to illustrate the problem.
    Cheers
    Andy
    www.andypope.info

+ 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] Convert two dimensional row to column data to a hard-coded array
    By evancharles in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-07-2013, 03:15 PM
  2. [SOLVED] data series doesn't show up on chart
    By chemeng1T3 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-10-2012, 10:03 AM
  3. Excel 2007 : Use a variable instead of a hard coded value
    By ThomasHaller in forum Excel General
    Replies: 2
    Last Post: 12-15-2011, 01:45 PM
  4. Add Data Labels, Show Series Names
    By knightcloud in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-18-2011, 01:32 AM
  5. [SOLVED] hard coded text
    By William Benson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2005, 02:05 PM

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