SOLVED

Graph Help?

%3CLINGO-SUB%20id%3D%22lingo-sub-3266362%22%20slang%3D%22en-US%22%3EGraph%20Help%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3266362%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EBit%20of%20an%20excel%20rookie%20here.%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20automate%20a%20process%20which%20will%20enable%20me%20to%20add%20all%20the%20values%20of%20a%20particular%20group%20by%20name%2C%20and%20then%20generate%20into%20a%20graph.%20As%20it%20currently%20stands%2C%20I%20can%20create%20the%20graph%2C%20but%20as%20you%20can%20see%2C%20each%20line%20has%20its%20own%20values.%20I%20would%20like%20all%20of%20%22Special%20Moe's%22%20to%20be%20collated%20into%20one%20number%20so%20there%20are%20only%204%20colums%20on%20the%20graph%20I%20create%20(one%20for%26nbsp%3B%20each%20group).%26nbsp%3B%3C%2FP%3E%3CP%3EHonestly%20don't%20know%20where%20to%20start%20-%20please%20help!%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Adzy28_0-1648168894599.png%22%20style%3D%22width%3A%20616px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F358353i2931EB6761C83425%2Fimage-dimensions%2F616x268%3Fv%3Dv2%22%20width%3D%22616%22%20height%3D%22268%22%20role%3D%22button%22%20title%3D%22Adzy28_0-1648168894599.png%22%20alt%3D%22Adzy28_0-1648168894599.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3266362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3272059%22%20slang%3D%22en-US%22%3ERe%3A%20Graph%20Help%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3272059%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B-%20Thankyou!!%20Very%20helpful!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3266434%22%20slang%3D%22en-US%22%3ERe%3A%20Graph%20Help%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3266434%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1342926%22%20target%3D%22_blank%22%3E%40Adzy28%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20that%2C%20you%20need%20to%20summarize%20the%20data%20based%20on%20groups%20and%20then%20use%20that%20as%20a%20source%20for%20the%20graph.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20attached%2C%20column%20E%20shows%20the%20unique%20group%20and%20column%20F%20has%20their%20total%20values%20and%20the%20graph%20is%20inserted%20using%20the%20data%20in%20columns%20E%20and%20F.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Graph.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F358381iAEF126E5A37DD09E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Graph.jpg%22%20alt%3D%22Graph.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3419983%22%20slang%3D%22en-US%22%3ERe%3A%20Graph%20Help%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3419983%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1342926%22%20target%3D%22_blank%22%3E%40Adzy28%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20a%20sample%20image%20of%20the%20chart%20and%20data.%20Chart%20refresh%20automatically%20as%20you%20change%20your%20data%20selection.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20need%20to%20summarize%20your%20data.%20As%20you%20can%20see%20I%20attached%20source%20data%20and%20the%20chart.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20check%20here%20for%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22No%20Code%20Data%20Visualization%20Add-In%22%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMreGwrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3EMicrosoft%20Excel%20%26amp%3B%20Office%20365%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20if%20you%20are%20comfortable%20with%20Google%20Sheets%2C%20you%20can%20find%3CSPAN%3E%26nbsp%3Bit%26nbsp%3B%3C%2FSPAN%3E%3CA%20title%3D%22No%20Code%20Data%20Visualization%20Add-On%22%20href%3D%22https%3A%2F%2Fchartexpo.com%2FutmAction%2FNCtNVEMrZ3MrUUorTVNPRlRDTVQr%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehere%3C%2FA%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Qaiser_j_0-1653391375926.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F374574iB1DFBFAAD0EBEB31%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Qaiser_j_0-1653391375926.png%22%20alt%3D%22Qaiser_j_0-1653391375926.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

Bit of an excel rookie here. 

I'm trying to automate a process which will enable me to add all the values of a particular group by name, and then generate into a graph. As it currently stands, I can create the graph, but as you can see, each line has its own values. I would like all of "Special Moe's" to be collated into one number so there are only 4 colums on the graph I create (one for  each group). 

Honestly don't know where to start - please help! 

Adzy28_0-1648168894599.png

 

3 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Adzy28 

 

For that, you need to summarize the data based on groups and then use that as a source for the graph.

 

In the attached, column E shows the unique group and column F has their total values and the graph is inserted using the data in columns E and F.

 

Graph.jpg

 

 

@Subodh_Tiwari_sktneer - Thankyou!! Very helpful! 

Hi @Adzy28,

 

I attached a sample image of the chart and data. Chart refresh automatically as you change your data selection.

 

There is no need to summarize your data. As you can see I attached source data and the chart. 

 

You can check here for Microsoft Excel & Office 365.

 

And if you are comfortable with Google Sheets, you can find it here.

 

Thanks,

 

Qaiser_j_0-1653391375926.png