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?

[TABLE="width: 671"]
<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>[TR]
[TD="width: 239, align: left"]Month[/TD]
[TD="width: 152, align: left"]Product[/TD]
[TD="width: 183, align: left"]State[/TD]
[TD="width: 97, align: left"]Total[/TD]
[/TR]
[TR]
[TD="align: left"]Apr[/TD]
[TD="align: left"]Apples[/TD]
[TD="align: left"]California[/TD]
[TD="align: right"]14200[/TD]
[/TR]
[TR]
[TD="align: left"]Apr[/TD]
[TD="align: left"]Apples[/TD]
[TD="align: left"]Florida[/TD]
[TD="align: right"]1506[/TD]
[/TR]
[TR]
[TD="align: left"]Apr[/TD]
[TD="align: left"]Apples[/TD]
[TD="align: left"]Texas[/TD]
[TD="align: right"]42988[/TD]
[/TR]
[TR]
[TD="align: left"]Apr[/TD]
[TD="align: left"]Banana[/TD]
[TD="align: left"]Florida[/TD]
[TD="align: right"]1703[/TD]
[/TR]
[TR]
[TD="align: left"]Apr[/TD]
[TD="align: left"]Banana[/TD]
[TD="align: left"]Texas[/TD]
[TD="align: right"]4077[/TD]
[/TR]
[TR]
[TD="align: left"]Apr[/TD]
[TD="align: left"]Banana[/TD]
[TD="align: left"]Hawaii[/TD]
[TD="align: right"]9033[/TD]
[/TR]
[TR]
[TD="align: left"]Apr[/TD]
[TD="align: left"]Banana[/TD]
[TD="align: left"]Arizona[/TD]
[TD="align: right"]3488[/TD]
[/TR]
[TR]
[TD="align: left"]Apr[/TD]
[TD="align: left"]Banana[/TD]
[TD="align: left"]Alabama[/TD]
[TD="align: right"]3488[/TD]
[/TR]
</tbody>[/TABLE]


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.