No Title for Second Column Selected in Chart on Dashboard

KatieS

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!

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?

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