Column / Bar graphs with series name as categories in horizontal / vertical axis

Dear Community,

I'm trying to create a bar chart to show when a team is planned to perform depending on the week of the year, in a time frame of 12-weeks. The week's time frame is dynamic, and is updated by formulas depending on the current week's value.

My data is set up as in the next image, where cells having a '1' represent the team is scheduled.

I'm trying to show this in a chart similar to the one below but I am having the following issues:

a) I can't make the FW's to be shown in the horizontal axis

b) I can't make each Team, to have 1 series for all weeks (each week is being considered as 1 individual series)

The image below shows what I achieved by using stacked bar chart, but still is not fully as I need it.

Thanks in advance for your hints and answers.

Juancarlos

Find more posts tagged with

Accepted answers

All comments

Naeem Ejaz

Smartsheet’s chart widget uses:

Columns as data series, and
Rows as labels (categories)

So if your FW (Week Numbers) are column headers, Smartsheet won’t display them on the X-axis.

You need to transpose your data.

Juancarlos MORALES

Hello @Naeem Ejaz,

Thanks for your answer. It did fixed the issue to display 'Week Numbers" on the X-Axis. What I am missing is to have the series name in the Y-Axis. Any hint for this other topic?

Thanks in advance.

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.