Ok, so I have had a look and cannot find the answer to this one! I have a pivot table which has two columns of data which is fine, however I also want a clustered column bar graph as well. however when I have the pivot table so one of the values is SUM rather than count the graph shows the columns as stacked on top f each other rather than side by side for each value on the horizontal axis, how do I stop this from happening?? This happens even if i put one of them on a second axis. I have attached an example of what I mean - the first chart is showing a count of both values and the second is using a SUM value for example 2 column.
Bookmarks