How to generate a column chart off a lookup?

[Anthonylucian]

Hey! I have a lookup where we manually enter in a number to a corresponding day. It looks something like this.

Monday | 2

Tuesday | 3

Wednesday | 2

Thursday | 5

Friday | 3

Is there a way to make this into a column chart where the x axis is the days of the week and the y axis is the corresponding number?

I tried to just put it in a column chart but it defaults to flipping the x/y axis, I then tried to transpose but along it still doesnt format correctly.

[s2_splunk · Accepted solution]

This should work as long as your fields are returned in the correct order, i.e. day name followed by the numerical value. You can always add 

| fields weekday, number

to ensure that.

[Anthonylucian]

Thank you!