New at Graphs, etc

[RYfromVan]

Hi everyone, first time poster but read the forums often and have learned a lot.
I dont use the graphs, etc in Excel very often

I am trying to find the best way to display this info in a graph (the boss is persistent that it be graphed. I have put in a bar chart, but now they are asking if it "can be aline or something"). I have shown a mockup, but my real data has 6 years and 10 categories.

	Gidgets	Gadgets	Wazoos	Brain Cells
2014	2.5%	3.2%	5.6%	6.4%
2015	2.5%	3.5%	8.5%	24.6%
2016	1.5%	-2.0%	-3.5%	-4.5%
2017	6.0%	5.0%	5.0%	5.0%

<colgroup><col width="64" span="5" style="width:48pt"> </colgroup><tbody>
</tbody>

Any help would be greatly appreciated. I have played around with the various options, and changed the axis, etc but can't find one that doesn't look like a plate of spaghetti...

thanks

 

[sijpie]

I think it is going to be the plate of spagetti. Suggest you make three graphs:
barchart, linegraph, areagraph and show these to various people ncl your boss. See what they like best.

There are some ways to make very smart graphs (see peltier.com) but this is a fairly simple dataset and there are only so many ways in which you can illustrate it.