Need help

  • Resolved meek4450

    (@meek4450)


    7 years, 8 months ago

    I finally figured out how to show the chart, but I’m trying to figure out how to isolate one column, not show all the blanks and create the chart.
    I want the name, only one column with date and only if the cell has a value.
    ALso, because there are 30 names, I want it to all show on one chart with no options to go to the next. (Chart: bar)

    Sample Data
    Name 3/1/2017 3/2/2017 3/3/2017
    Xyla Turner
    Denny S. Bryce 8000
    Nicole Howard 1211 1422 0
    Patrice Michelle 153
    Cherae Mabry 2000
    Tysha Jordyn 3213 4116 7508
    Victoria Bright
    Blaq Phire 1500
    Sydney Aaliyah 0 4505 3006
    Deidra Green 1750 4576

Viewing 4 replies - 1 through 4 (of 4 total)

  • I’m not the plugin author, but I’ve played with charts quite a bit. And I know what the author expects in a question.

    You could look at filtering your Google sheet to eliminate the values. It might work.

    Also, maybe you can clarify the question more. For example, “only one column with date” since you have three date columns, some of which have data.

    How are you imagining tha chart to look with 30 names? Stacked bar?

    Thread Starter meek4450

    (@meek4450)

    Yes, the sheet includes names of different people and the column is a day in each month. I just want to create a graph that will show the names, one day (one column) and graph it using bars or ___ without the blank items included.

    I gave three columns as an example of how this would look and what would need to be removed.

    In the FAQ, look at the “query” parameter and the link to the Google documentation for using it. You should be able to write a query string that selects just the columns and rows you want using SELECT and WHERE.

    Plugin Author Meitar

    (@meitar)

    Thanks, @tangobango. ??

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Need help’ is closed to new replies.