How to create chart?

**Formats74** · 03-21-2017, 07:10 AM

Hmm, I´m stumped.

Im trying to create a chart based on the following data:

Monkey 5
Bear 5
Monkey 2
Monkey 4
Bear 3
Dog 7

I want the chart looking something like this:
chart.GIF

Any ideas how to do this? Im using excel 2016.
Regards
Mattias

**MrShorty** · 03-21-2017, 10:32 AM

I find that a lot of charting questions have more to do with the spreadsheet than with creating the chart. The key to creating this chart is to get the data arranged from this nice list into a nice table. Perhaps the easiest way to do this is to use a pivot table, then create a pivot chart from the pivot table. http://www.excel-easy.com/data-analy...ot-tables.html Use animal name as your row labels, the values as your column labels, and sum of values inside of the pivot table.

**Formats74** · 03-22-2017, 05:30 AM

Thanks!

But I had already manually set up the data in the same way the pivottable does to try that but I´m still not able to get it to work. Which type of chart would you suggest?

**MrShorty** · 03-22-2017, 08:43 AM

What I see in your picture is a regular line chart with the series formatted as marker (x) without lines.

**stasinek** · 03-22-2017, 09:13 AM

Hello,
I do not know what you want to accomplish with your data. My proposal using Power Query - but maybe the author has other needs :-)
You need to have PQ installed to be able to refresh the data.