How can I add the first column as series labels if they are greyed out...?

I have created a dashboard widget - a column chart displaying data per year falling into certain categories. I have one sinlge grid containing the data, where the first column contains the years, then the data is coming in the next ones, and there is a column for summing up the data from each category.

If I plot the grid on a column chart, all categories are visible, and the year is displayed correctly as a series label. However, if I chose only the TOTAL columnt to be displayed, the year numbers are gone, and the option for selecting the first column as series labels disappears.

I just re-created my table with dummy data, and the result is the same. I guess, this is a bug in your system, right? It is not possible to use the first column as series labels as soon as not all columns are selected. If I go back, and chose 'all columns' again, the option for using the first column as series labels comes back.

could you please look into this? It is quite annoying,

Is there anything I have missed here concerning creating charts?

Thanks,

Zoltan

Find more posts tagged with

Accepted answers

All comments

Jeff Reisman

@zoltan.dobai You have two easy options:

A) Move your TOTAL column so that it's to the immediate right of the YEAR column, and then just select those two columns for your chart.

B) Create a report with your grid sheet as the source, and only include the YEAR and TOTAL columns in the report. Use the report as your source for the chart.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.