How to create a chart from a report!

Alicia D

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!

juliesilverio

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!

juliesilverio

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!

Alicia D

Ahh yes, this worked. Thank you!

juliesilverio

https://community.smartsheet.com/discussion/comment/414201#Comment_414201

Happy to help! :)