This is a migrated thread and some comments may be shown as answers.

[Solved] Chart Grouping

2 Answers 108 Views
Chart
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Tony
Top achievements
Rank 1
Tony asked on 10 Nov 2011, 07:38 PM
I can't seem to find documentation or a way to group the data like you would in Excel when creating a chart.

I want to provide a data set that has a category (date), a series owner (city) and value, so that it looks like the attached. The category should group by date, and the series should group by name (city) with the value being the result so that I get a line for each series owner

Is it possible?

2 Answers, 1 is accepted

Sort by
0
Tony
Top achievements
Rank 1
answered on 10 Nov 2011, 10:04 PM
So it seems that either I'm missing something or the charting is quite limited. I just modified the samples by adding additional SalesData points for August and September with a different name.

Based on the way charts work, the sales figures for Aug/Sept should have included the additional data in those months, but it didn't, instead it just added two more entries for those months show 2 points for Aug and Sept.

Can this be confirmed as by design, a work in progress or I don't know how to use the charting.
0
Rafael
Top achievements
Rank 1
answered on 29 Dec 2011, 02:48 PM
any progress how to implement multiple Lines in chart?
Tags
Chart
Asked by
Tony
Top achievements
Rank 1
Answers by
Tony
Top achievements
Rank 1
Rafael
Top achievements
Rank 1
Share this question
or