Target in Chart

[Dave_Willett]

Hi. I have a monthly sales target which I would like to show in a chart along with the sales actual sold.
Is this possible and how would I do this?

Kind Regards

[WillowMobileSys]

Hi! There are a few ways to do this. First in your data you need the x axis part of a chart - e.g. Month. Then you need the Target and Actual Sales number for each x-axis point.

I created a simple example where I have Month, Actual and Target. But these values can be part of a much larger row.

Now just create a Chart view. Below are a few examples of what i think are the best options. Please post again if you have more questions.

---

Line Chart -Column series - Target is the same each Month

Line Chart - Column series - Target is different each Month

Bar Chart - Column series - Target is different each Month

[Suvrutt_Gurjar]

Very well illustrated @WillowMobileSystems.

[Dave_Willett]

Hi Guys. This is very useful, if I can configure my csv along this theme then this will be a great solution.
Thank you.

[Dave_Willett]

Voila