Stacked bar chart that only goes to 100%

Hi,

I'm trying to create a stacked bar chart that combines the Actual number, the Deal Model Number, and the projected number into one line. I'd like the bar chart to only go to 100% and as the Actual number goes higher, it shows it creeping up the bar towards the deal model / projected number. I'm not even sure what kind of formula I would use for this. I have the three numbers in a separate sheet that are to be updated manually by another department, so there are no dependencies on them. Thoughts?

Thank you!

Find more posts tagged with

Dashboards

Accepted answers

All comments

Leibel S

@Emily T.

In a sheet being in each of the numbers into their own column.

then you make a column for each of them (which is the value you want for the chart). These would be a formula that is: the value / the total value

Not sure this explains it in full, but try building on it...

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.