No Title for Second Column Selected in Chart on Dashboard

Hi Everyone,

Thanks for your help.

I've got a few spreadsheets with data collected, and I'm trying to make a chart on a dashboard. I'm very comfortable in Excel, but for some reason I can't get the title for the second column to read in my charts. I have flipped back and forth between "Switch Rows/Columns" and that doesn't help. It's still missing the names of the data. It's not a useful chart without the data.

The videos are of no help. They just tell you how to create a chart. There's nothing available on Troubleshooting.

Thanks!

Find more posts tagged with

Sheets

Reports

Comments

J. Craig Williams

I don't know exactly what you are looking for, but based on where your chart is in the image:

Under Chart & Data: check the [ ] Use first column as labels

Under Titles & Legend: change Legend to "Bottom"

I hope this helps.

Craig

Ben Donahue

How do I get my "Use first column as labels" not to be grayed out?

use first column as lables smartsheet.PNG

Jackie Callahan

@Ben Donahue Ben, did you ever get this figured out? I'm having the same issue, 'Use first column as labels' is grayed out for me too.

Thanks!

EhsanMir

I have the same issue

Sign in to join the conversation!

Quick Links

Trending discussions

Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…
Column with a restricted list very difficult to edit
Hello, I have a column with a restricted list of 100 entries. When I edit the list and scroll to the 50th entry, as soon as I type to change the entry name the column scrolls to the top and I cannot see what I am typing or deleting. I have to keep scrolling back down to the row to see what I have keyed in. Very annoying…
Web Content Form Not Working on Reload
I have a web content widget on my dashboard that displays a Smartsheet Form. I have the form set to reload the form for another entry when an entry is submitted. When the user goes to use the newly refreshed form, dropdowns do not populate (i.e. Contact Lists). Dates and text work fine.