View original (French)

Stacked chart: display totals

Anonymous user -  
 Anonymous user -
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 answer

  1.
    via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    Hello

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

    Best regards
    Via

    --
    "Imagination is more important than knowledge." A. Einstein
    1
    1. Anonymous user
       
      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
    2. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759 > Anonymous user
       
      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
    3. Anonymous user
       
      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
    4. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759 > Anonymous user
       
      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
    5. Anonymous user
       
      It exists in my pivot table, I can see it, but it is not taken into account in my pivot chart.
      0