line chart with second line

[rrmcguire]

Hello,

Im currently trying to build a line chart where for my x axis is a datefield(pickupdate)showing month by month and my y is a summary of a field dispatch profit.

What Im trying to have is another line as a comparison vs. the above. This line is based on monthly goals which are put in as parameter fields for each month

ex. March actual dispatch profit = 63000 vs. goal = 60000
April actual " ' = 65000 vs. goal = 60000
May actual " " = 67000 vs. goal = 65000

thanks

 

[rrmcguire]

what determines what fields are "available fields" to be used in the Chart Expert. I thought I could get this working by having the goal, @goal = Pm-Goal, where the user enters in a value for that goal as it stays the same for each month, then adding @goal as a second value to chart along with my summary of dispatch profit. But my @goal is not available as one of my fields, is this possible to add a second line for my date range if the values for that line are the same for each time period?

thanks