How to create a chart from a report!

Hello! I am trying to create charts using multiple sheets so I created a report. Although I am not able to figure out how to make it a chart. When I go to chart, it is all grayed out and won't let me select anything. I read that you needed to have a summary section and a group section, so I included both, but I still can't figure out how to get it to work. Any help would be appreciated!

Best Answer

  • juliesilverio
    juliesilverio ✭✭✭✭
    Answer ✓

    Hi Alicia,

    When you say the report is grayed out, are you still able to click the blue "OK" button in the bottom right? It won't let you select the data you want charted at this step. You can do that in the next step under the "Columns Included" section of the Chart Widget.

    If you're unable to click the blue "OK" button (this has happened to me a few times) I have found that double clicking on my report name when I select it has sometimes worked. Otherwise it may be your browser settings interfering with the setup. I use Google Chrome and very rarely have this issue now.

    Hope this helps!

    Julie Silverio, PMP

    Senior Manager, Program Leadership

    Xencor Inc.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!