2010 Charts Question and assistance

[jcalvacca]

Here is an image for what I want the end chart to look like.

https://imageshack.com/i/p8D2admuj

I am having all kinds of issues on this and I believe (at least I think) it should be simple to make.

Right now, I have the data in two columns....

A column reads the 3 different kinds of fruit.

Be column has all the different quantities that have been recorded.

Thanks in advance!!!

 

[eibi]

See attached as a starting point -- is this where you want to be?

 

[jcalvacca]

Closer....
The "Legend" needs to be dynamic as this will grow with different types of fruit.
The X Axis (tickmarks) need to change as well with the new fruit.

List of different types of fruit will not be limitless.....will only be about 30 or so.

Thanks for the help!

 

[eibi]

Like so?...(attached)

There's room for 100 entries in your source data column and up to 50 different types of fruit...

 

[jcalvacca]

Solid solution....how did you get those areas to "gray out"? I haven't seen that one before....

Thank you!!!!

 

[eibi]

Nothing special...I just changed the borders and font color to gray.

Glad that it's going to work for you.

All best.