Solved

Excel 2007 Graph not showing correct data

Posted on 2013-06-11
8
265 Views
Last Modified: 2013-06-11
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
Comment
Question by:jtbrown1111
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 19

Expert Comment

by:helpfinder
ID: 39239165
there are 2 graphs in the sheet, which one do you mean?
0
 

Author Comment

by:jtbrown1111
ID: 39239201
sorry .... its the first graph ....   and the " New " value shows as 109 and should be 252 from the data source .....
0
 
LVL 19

Expert Comment

by:Raheman M. Abdul
ID: 39239235
See the result file. attached.
Patient-Appts..xlsx
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 19

Expert Comment

by:helpfinder
ID: 39239237
0
 
LVL 19

Assisted Solution

by:Raheman M. Abdul
Raheman M. Abdul earned 200 total points
ID: 39239240
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
 
LVL 19

Accepted Solution

by:
helpfinder earned 300 total points
ID: 39239243
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
 

Author Closing Comment

by:jtbrown1111
ID: 39239301
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
 
LVL 19

Expert Comment

by:Raheman M. Abdul
ID: 39239323
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

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question