Stacked Chart

Shesha_K
Shesha_K ✭✭✭
edited 12/09/19 in Smartsheet Basics

Hi All!

I am trying to move a document from excel into SmartSheet and I was wondering if anyone knew if I could recreate this data into a dashboard chart?  It is not currently set up as a chart in excel, it is a tedious exercise of lengthening and creating new shapes to designate the progress. I have tried a couple different ways and I am not able to recreate this data. Ultimately I would like to be able to type a number in designating how far we are in the process. Green indicating we are still moving forward, yellow designating a delay, and orange indicating that the progress is on hold. Everything I manage to create shows the numerical data, whereas I was hoping it could just show the company name, the phase of progress, (identify, pursue, refine, etc.) and the bars. 

smartsheetchart.JPG

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Based on your description, this should be possible to an extent. We wouldn't be able to split the columns the same way you have in the above screenshot, but we may be able to help come up with something that will work (and automate the process).

     

    Can you provide more details as to how you come about your results? Maybe some screenshots of the source data (sample data if fine)?