Sign in to join the conversation:
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
Use a report to get the columns then reference the report for the dashboard chart.
Hi Tim,
To select discontiguous columns, first select the full range of columns that encompasses all the columns you want to use. Then in the Edit dialog, click the "Select Columns" button to select only the columns you actually want to display.
Thanks Luke
Thanks Anthony perfect.
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
