HI all



I have some data in an excel file that I would like to make into a chart. I checked a few places and could not find an example that was what I was looking for. I am attaching the excel file with the data and below the data I have a mock chart to describe how I am trying to make the chart look like. Any assistance would be greatly appreciated.

Thanks

Attached Files

Fruit Example.xlsx (29.0 KB, 6 views)

Its a bit of a bodge as the data is not in a tabular format, but is this what you are after?


Please do not use merged cells they are the wrose thing you can out on a spreadsheet as they will only cause problems

Attached Files

Fruit Example_PURFLEET.xlsx (34.7 KB, 8 views)

Thanks Purfleet, yes that is exactly what I was attempting to do. This is perfect!!!