Can you have a bar graph widget, automatically update the source range

Hello,

I was wondering if it was possible to have a bar graph widget update its source range update automatically?

For example, I currently have a bar graph that shows data from April, May and June - the numbers within these do update as new data is added.

When it's the end of September, the bar graph will need to show July, August and September data only.

Is it possible to setup the bar graph to do this or would it need to be done manually?

Thank you.

Find more posts tagged with

functionality

Automations

Accepted answers

All comments

Jgorsich

Make a helper sheet that pulls the correct data you want from your source sheet - tie the formulas to the current month and make them so they auto-update as a function of date. Then, rather than graphing from your source sheet, graph from your helper sheet.

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.