Chart Issue
Hi,
I have 2000+ row of data.
When i create a chart, instead of summing up my $ amount with the same categories (for example item A and item 
, it create the bar according to number of items.( for example: item A has 3 items, it appear 3 bar).
Anyone can help on this?
Thanks
Comments
-
Hi Wilson,
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, [email protected])
Happy New Year!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Have you tried using the "Switch rows/columns" button?
-
As Andree is suggesting, it would be helpful to know how you created your chart. If this was me, I would have created a new sheet and used cross sheet formulas to sum the categories using SUMIFS and then based that chart off of my new summary data.
