Scatter Plot help -> categories with data point values

[rogerdavid]

Hi,

I'm trying to set up a chart to represent monthly data, across the past 12 months.


My data looks something like this, from a pivot table:

Jan - 1.2, 0.5, 0.7, 0.1
Feb - 1.1, 1.4
Mar - 3.2, 0.1, 0.2, 0.4, 1.1, 4.7, 1.3
Apr - 1.12
etc...
etc...

The month values are more than 400 cells across, but 90% of them are NA().

So across the X-axis I'd like "Jan, Feb, Mar, April, May... etc"

And the y axis I'd like the values that belong in that month.

I'd like the chart to look something like this....

Untitledjp.jpg


How would I set it up? I think im having a brain fart

[rogerdavid]

Nevermind - brain fart solved. Cheers for reading. Doh.