+ Reply to Thread
Results 1 to 1 of 1

Chart Source values showing as zero in chart

  1. #1
    Registered User
    Join Date
    Brisbane, Australia
    MS-Off Ver
    Excel 2007

    Chart Source values showing as zero in chart

    Daily Disaster Report.jpg

    Hi, I have a very frustrating problem. A colleague has a dashboard which contains a number of charts. One of the charts source data is another tab in the spreadsheet. There are 5 line items and 2 of the values come from a cell reference to another spreadsheet, the remaining 3 are just numbers. The 2 cell references values show as zero on the chart. Why is this happening? There are other charts in the dashboard which use values from a spreadsheet that have Vlookup formulas and they work. Help!! Hope the attachment is there, which shows the problem

    I just asked an Excel guru here and she suggested put VALUE(<Cell Ref>) in front of the reference and it worked! Thought I would share the solution. If anyone has other suggestions, they are most welcome.
    Last edited by Bernieboo62; 01-29-2014 at 11:05 PM. Reason: Solution found

+ 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. Replies: 1
    Last Post: 07-14-2012, 11:46 AM
  2. Line Chart series showing values for NA()
    By dcgrove in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-22-2012, 04:45 AM
  3. Excel 2007 : Values not showing correctly in chart
    By kuroneko4 in forum Excel General
    Replies: 1
    Last Post: 01-21-2010, 12:54 PM
  4. Line values not showing by cursor in chart
    By BCB in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-07-2007, 12:27 PM
  5. How can I prevent a Chart from showing zero values?
    By Quinn Ramsey in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 07-27-2005, 10:05 AM


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