how to create target lines in linear excel graph?

[gimran]

I want to create a linear chart with a target line. How can i do that?

 

[mole999]

you normally just model your target as a new set of data and then include it in the mapping

 

[gimran]

Sorry, could not understand. can you please elaborate with example.

 

[mole999]

in your data if 75 is the target you add 75, 75, 75, 75 etc in an additional row and include that in your chart > http://peltiertech.com/