We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Stacked bar chart, multiple rows [closed]

asked 2016-08-09 23:07:09 +0200

ctheobald gravatar image

I would like to produce a bar chart with the x-axis being date and a single bar per date. The bar would have multiple sections, one for each row in a particular date and the magnitude dependent upon a third column.

My data has the first column as a date, the second column a user name, and the third column a quantity. There may be multiple rows for any given date, one row per user name and usage quantity. Each column section would reflect the usage for a user on a date.

Google has not helped so far.

Thank you, Chuck

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-10 14:30:38.274329

2 Answers

Sort by » oldest newest most voted

answered 2016-08-11 04:25:14 +0200

mikebibo gravatar image

Perhaps the easiest way is by rearranging your data. This can be done with a pivot table, so that you end up with dates as rows, usernames as columns and quantities as data. Remember to de-select row and column totals, as you probably don't want them included in your barchart. From there, simply selecting a stacked barchart should give you want you want.

edit flag offensive delete link more

answered 2016-08-11 18:32:13 +0200

ctheobald gravatar image

I went down this route and had some problems, but this was related to the fact that the upper left cell was empty in my pivot chart. This led to some odd and frustrating behavior. My solution was to copy the pivot table data and paste into another sheet, put 0 in the empty upper left cell, and then generate the stacked bar chart. I've now got the chart that I wanted.

Thanks to mikebibo. I would upvote their answer, but I do not have the points yet.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-08-09 23:07:09 +0200

Seen: 3,298 times

Last updated: Aug 11 '16