Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mphekin12
Specialist
Specialist

Line Chart Formula Question

Please help with this tricky situation that I have.  I have a request from finance to put the following information into a line chart.  They want me to compare the 2013 vs 2012 by month for the last column in the attached screenshot.  Basically I'm dividing our Inventory $ by the sum of the last 12 months of Sales.  The formulas that I am using work great in a straight table, but not at all in the line chart.  Can anyone offer any assistance?

Thank you!

Capture.PNG.png

1 Reply
Not applicable

I can provide some data for testing