Graph data is on wrong reference point on graph.

NThompson7* · 08-31-2015, 03:35 PM

I am working on a line graph created from a pivot table. The data on the graph is not showing up on the correct place on the graph. (e.g. the amount is -14.32% and is graphed at 8.98%) I have the values setting set on sum and it looks like it is calculating the sum and graphing on that amount. My problem is I am not sure what the values setting should be and if this is the only problem. Your help would be greatly appreciated.

Pivot Table Graph.xlsx

**Kaper** · 09-02-2015, 04:12 AM

As a matter of fact nothing to really check, because you just pasted some screenshots into a workbook, but gave us no chance to experiment and really check what (if) you did wrong.

So attach a sample workbook. Make sure there is just enough data to demonstrate your need. Show what is now and show/tell/let us know what you expect it shall be.

Remember to desensitize the data.

**MrShorty** · 09-02-2015, 08:40 AM

As noted an actual spreadsheet would be more helpful.

As a guess, what chart type did you use -- regular line chart, or stacked line chart? It appears to me that you have used a stacked line chart, where the position of each point is relative to the previous point. If I understand your question, I wonder if changing the chart type from stacked line to regular line fixes your problem.