Skip to main content

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!!

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.

 


Reply