Forum Discussion
Target Line on Charts
How do you insert a target line into charts? I have created the chart but want it to show the target line for monthly sales achieved. The chart has the monthly totals as per below but I want a hori...
PLiscia008 In that attached I copied your data, created a fictitious Target and created a COMBO graph. You can select your graph and go to Chart Design -> Change Chart Type or start over. Just for fun I added all the parts so you can see how it all 'stacks up'. So the parts and 'Target' are all on the primary axis and the Total Month is on the secondary axis which I hid and set the fill and border to 'none' so it isn't on the main graph just on the data table.
- mtarler thanks that helps a heap. Will have a play & see if I can get what I need done.
