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, andree@getdone.se)
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: andree@workbold.com | 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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives