Legend and Labels not showing correctly

I was curious how to not show rows that are “null” or zero values

You can use the query attribute to write a SELECT statement that only returns certain rows, columns, or values to your shortcode. Check out the Google Query Language reference for more info on the select statement.

I’m not sure if its something in my spreadsheet? or if its something i’m not doing right when setting it up on wordress?

I suspect you’re missing some attributes from your shortcode; the values are all there in the chart, but Google Chart automatically summarize the axis and legend labels. You may need to use the series property the Google Chart API (through this plugin’s chart_series attribute) for more fine-grained control. Have a look at Google’s documentation for Bar Charts for more info.

This is the shortcode I’m using.
[gdoc key="https://docs.google.com/spreadsheets/d/1LXhz_gsUE7O7NXI5NbL0rHFWOGVgQEfZFVRlPuBh1Vc/edit?usp=sharing" query="select A, B, C" chart="Column" ]
I’ve looked everyhwere and can not find an answer to what is wrong. thats why I am asking here. If you could maybe help me..i would really appreciate it.
thanks again!

Also on the “null’ I have looked at the google Query language reference but cant figure out how to put it into the shortcode. thank you!

I figured out the Legend. I guess I because they were numbers they werent showing up. I changed the format to Text and they are now showing.

If you could help me on the “null” rows..that would be great!

Thanks again!

Glad you worked it out.

If you could help me on the “null” rows..that would be great!

Again, you should really just consult the documentation, which explicitly addresses how to filter for or out null values. If you have specific questions after doing so, I might be able to offer more help, with less of an attitude. ?? It’s neither fun nor useful for me nor you to just quote the documentation back at you.