dprasad
asked on
Excel 2007 Graph not correctly representing data
hi, in the data set for the chart in the sheet ther are values less than 100, but the payroll timeliness line only graphs 100. anyone know why this is? Book2.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The values for the timeliness really are all 100 in the data you are referencing in the chart, which as teylyn and mattewspatrick pointed out is actually in another workbook. You can see that this is the case even without having the external workbook by going into Data...Edit links and breaking the link - Excel then shows the data values hard-coded as an array in the series formulas - and they are all 100.
I suspect you copied those charts into this workbook from another without redirecting the data source for the chart. As teylyn has partly done, you need to recreate the charts using the data on the current worksheet.
I suspect you copied those charts into this workbook from another without redirecting the data source for the chart. As teylyn has partly done, you need to recreate the charts using the data on the current worksheet.
='C:\Documents and Settings\dpra6551\Applicat
So, I would look in THAT workbook/worksheet, and see if the values are all 100.