##### New Member
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>

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### Giordano Bruno

##### Well-known Member
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.

Replies
5
Views
255
Replies
2
Views
294
Replies
1
Views
249
Replies
5
Views
410
Replies
1
Views
325

1,109,378
Messages
5,528,341
Members
409,817
Latest member
JiNXX9500

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...