Skip to main content
Solved

100% Stacked Bar Chart

  • September 5, 2017
  • 1 reply
  • 28 views
R
Forum|alt.badge.img

Is it possible for FME to create a 100% Stacked Bar Chart, given the following scenario?

  1. I have 7 years of roadway data (2010-2016)
  2. Each year contains a count of miles classified as Good, Fair, and Poor. For example:
    1. 2010, Good = 1217 miles, Fair = 302 miles, Poor = 77 miles, Total Miles = 1596
  3. For the same year, the percentages are Good = 76%, Fair = 19%, Poor = 5%
  4. Can someone please point me in the right direction for depicting this as a 100% stacked bar chart for years 2010-2016?

Thanks!!

Best answer by fmelizard

Hi @randall_robie

 

 

I'm guessing you mean in Excel? A good way to do this would be to build the graph in Excel with some sample/dummy data and then use the file with the graph as a template in FME when writing it out. Here's an article which shows a similar process.

 

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    1 reply

    fmelizard
    Safer
    Forum|alt.badge.img+20
    • fmelizardSafer
    • Safer
    • 3719 replies
    • Best Answer
    • September 5, 2017

    Hi @randall_robie

     

     

    I'm guessing you mean in Excel? A good way to do this would be to build the graph in Excel with some sample/dummy data and then use the file with the graph as a template in FME when writing it out. Here's an article which shows a similar process.

     

    Community Stats

    32,093
    Posts
    121,876
    Replies
    39,733
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.