Hello,
somehow I can't combine charts with a grouping by customer (it's a report about complaint quotient, therefore
i need to group invoices and complaints by customer).
I want a chart which iterates for each customer that shows me at a glance how many complaints
he has got, but I can't get it to work.
I have 3 customers in my report, but only 2 charts are shown.
Additionally, the second one is based on the data of the first customer.
That's why the chart does not accept a relative address.
All the time I change it to be relative, it stays the same (absolute) after confirmation.
Does anyone have an idea?
Thank you in advance.
Date
Votes
3 comments
-
Jet Reports Historic Posts Can you post a simple example spreadsheet of what you're trying to do?
-
Jet Reports Historic Posts Of Course.
This one does not make any sense, but it shows what the trouble is.
The chart should be repeated for each customer but it does only two times
and is always attached to the first customer.
I can't change the relation to be relative in the chart's data and
thus I don't receive correct values. -
Jet Reports Historic Posts You should make a dummy row (row 8), you can even insert data there to see your graph work.
After that, you let Jet hide it, hidden rows aren't shown in graphs in excel.
That should do the trick.
Please sign in to leave a comment.