View original (French)

Stacked chart: display totals

RachelMartel Posted messages 460 Status Membre -  
RachelMartel Posted messages 460 Status Membre -
Hello,

I have a chart that pulls its data from a large, constantly evolving database.

The chart is formed from two pieces of information: a date and a priority level (normal or urgent). So, in the chart, we can see for each week or each month how many "normal" and "urgent" data items there are. Therefore, if I have 5 "urgent" and 15 "normal," I would like the number 20 to display above the bar.

It seems simple like that... but I can't manage to do it :(

Thank you!

Configuration: Windows 7 / Chrome 45.0.2454.101

1 réponse

Réponse 1 / 1
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
Hello

A small example:
http://www.cjoint.com/c/EJbhMetmSeY

Best regards
Via

--
"Imagination is more important than knowledge." A. Einstein
1
RachelMartel Posted messages 460 Status Membre 25
 
Yes, I know this solution, but it doesn't apply in my case, because my data doesn't present itself like that. Example:

September 15: urgent
September 15: urgent
September 15: normal
September 16: urgent
September 16: normal
...
etc.

I would need to create a pivot table, but my problem with this solution is that I also can't display the total in my chart, because I can't add the "overall total" column to my chart.
0
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755 > RachelMartel Posted messages 460 Status Membre
 
Re,

Personally, I don't understand how you can have a stacked chart with the data in a single column.

Post an example of your file with the table and its chart on su cjoint.com, create the link, copy it, and come back to post it here; we might see more clearly to find a solution.
0
RachelMartel Posted messages 460 Status Membre 25
 
Excuse me, I just rechecked my chart that I created several months ago and it is actually a pivot chart, made from a pivot table. So I have a somewhat similar table to your example, but as I mentioned earlier, I can't seem to add the "grand total" column to my chart.
0
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755 > RachelMartel Posted messages 460 Status Membre
 
Hi,

Your overall total column needs to already exist in your pivot table; it doesn’t seem to be the case at the moment.
0
RachelMartel Posted messages 460 Status Membre 25
 
It exists in my pivot table, I can see it, but it is not taken into account in my pivot chart.
0