I'm trying to make a simple chart displaying the number of events that occurred each month in X years. This means I want a chart that shows:

  1. X colored lines, one for every year
  2. Month names marked on the X axis
  3. Event counts on the Y axis

graph drawn in MS Paint

My table looks (it's Czech but I suppose it's comprehensible) like this:

Google Sheets screenshot

I tried all I could think off, but the chart keeps putting years on X axis and sometimes produces a total mess.

If I select Table option in the chart editor, I get this mess:

click for JSFiddle link

Is the chart even capable of rendering what I want?

I mean, my request is quite basic I'd say - so how come it took me so long and it still doesn't work?

  • 1
    @pnuts to the rescue and +1 for the drawings !! Dec 26, 2014 at 19:17
  • btw, are you using a script to create the chart? If so, please add the tag Dec 26, 2014 at 19:32
  • @JacobJanTuinstra no, I'm using their GUI editor. I may have chosen wrong title phrasing. Dec 26, 2014 at 19:50

1 Answer 1


Select all your data including labels and insert a Line chart. Then in Chart Editor check Switch rows/columns, Use column A as headers and Use row 1 as labels:

WA71257 example

  • 2
    Thanks it worked. I wonder why didn't I see the "Switch rows/columns option before" Dec 26, 2014 at 19:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.