Graph Advice

[AnAppleADay]

Fairly experienced user of Excel but not really used anything more than a basic column/line graph for using two columns of data. I now have three columns of data and i feel like, with experience, it may be possible to work out a way to show the data in a useful manner - Though i haven't got a lot of experience with graphs so I'm after some advice or recommendation on graph graph and how i would go about implementing it.

My data is fruit sales across Southern American regions over the same time period (April to October) in 2018, later i would like to add in data for 2019. The only way i can think to do this is by narrowing it down to one month at a time (or one variety), but that's going to give me A LOT of graphs - Ideally i would like just one per month or by product - A snapshot of last year, fruit sales by country for the time period. I have attached an example below showing one of the months. The data i have for the other months is similar.

The issue i seem to be having is having multiples of the same product i the same month. Would a secondary axis work for this data?

Month	Product	State	Total
Apr	Apples	California	14200
Apr	Apples	Florida	1506
Apr	Apples	Texas	42988
Apr	Banana	Florida	1703
Apr	Banana	Texas	4077
Apr	Banana	Hawaii	9033
Apr	Banana	Arizona	3488
Apr	Banana	Alabama	3488

<colgroup><col width="239" style="width: 179pt;"><col width="152" style="width: 114pt;"><col width="183" style="width: 137pt;"><col width="97" style="width: 73pt;"></colgroup><tbody>
</tbody>

Thanks in advance for any comments or suggestions.

Ad

 

[Giordano Bruno]

The answer would seem to depend upon what you want the graphs to show. One technique I've used in the past is to have a graph show all data and then simply hide data rows or columns that I want to hide. That way, a single graph can be made to show comparative data for whatever combination you want to see. Maybe that would help you.