How to create dynamic chart?

[#1]

Hello,

I have a table data with salespersons,sales and goal.

i want to create a gauss chart for every salesperson, but the quantity of salesperson is different for each company.

The chart shows sum(sales) / goal.

I hope you can help me

[#2]

The guage chart doesn't support the Trellis feature, which would allow you to do that kind of stuff. One way to do what you desire is to use a Combo Chart to show the sales amount and the goal fulfillment by SalesPerson.

[#3]

I don´t know what is trellis feature. The clients want to see gauge chart for every salesperson.

If i have 5 salesperson in my dashboard i have 5 diferent gauge chart, one for each salesperson.

The combo chart i can see data in number, but they want to see data like a odometer.

Thanks for suggestion.

[#4]

Did you try gauge chart inside straight table?

Find attachment. It may help you.

Karthik

[Gysbert_Wassenaar · Accepted solution]

See attached example

[#6]

It is Good solutions...

thanks for sharing your knowledge..    

Karthik

[#7]

Thanks everybody.... this is a good solution.

[#8]

Dam I need a license soon, lol. Gysbert could you plz put some words in here, to give me an idear?