• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • Last Modified:

Excel 2007 Graph not showing correct data

I have an excel 2007 graph which will not show the correct numbers from the calculated cell.  I might be missing something and need someone to take a look at it ...

Tab is " 2013 New vs est " , first tab ....  Graph is is the middle of this worksheet .....



Thanks ....

Joel T Brown
Patient-Appts..xlsx
0
jtbrown1111
Asked:
jtbrown1111
  • 3
  • 3
  • 2
2 Solutions
 
helpfinderIT ConsultantCommented:
there are 2 graphs in the sheet, which one do you mean?
0
 
jtbrown1111Author Commented:
sorry .... its the first graph ....   and the " New " value shows as 109 and should be 252 from the data source .....
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
See the result file. attached.
Patient-Appts..xlsx
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
helpfinderIT ConsultantCommented:
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
The data series for New were:

=('2013 New vs Est'!$S$2:$S$4,'2013 New vs Est'!$S$6,'2013 New vs Est'!$S$6,'2013 New vs Est'!$S$6:$S$23)


I have changed them to:

=('2013 New vs Est'!$S$2:$S$4,'2013 New vs Est'!$S$6:$S$23)
0
 
helpfinderIT ConsultantCommented:
problem was you had this in Series values:
=('2013 New vs Est'!$S$2:$S$4;'2013 New vs Est'!$S$6;'2013 New vs Est'!$S$6;'2013 New vs Est'!$S$6:$S$23)

and correct should be:
=('2013 New vs Est'!$S$2:$S$4;'2013 New vs Est'!$S$6:$S$23)

those additional:
'2013 New vs Est'!$S$6;'2013 New vs Est'!$S$6;
made a mess with your data
0
 
jtbrown1111Author Commented:
Thanks goes to both " helpfinder " and "marahman3001" for both finding the correct answer to the problem.  The difference was first responder and listing what the actual problem was.  I really appreciate both of your amazing help and I'm greatful for having you on the expert-exchange team .....
0
 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
Thanks for the comment jtbrown1111. Puzzled that i am 2nd responder! even though I posted the answer as well as the error info first.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now