Create a special type of chart in a Table

[#1]

Hi,

I'm trying to create a chart based on de pivot table

It would look like this:

Year	Month	TaskType	Days Spent on Project	Days spent on Sales
2010	Jan	Project
		Sales
		…
	Feb	Project
		Sales
		…

I'm using this formula: if(Tasktype='Sales', sum(DaysSpent). I would present the measures with a line-meter so i would look like mini-barcharts.

Is this possible to do?

Thankx!

[#2]

Hi.

Perhaps an example will do?

[#3]

Thx!

I've now solved it using a pivot an using a lineair meter t show the results. No need of a chart or difficult calculations ....