User Profile
Qaiser_j
Brass Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: Pivottable / Charts: How to sum up questions with different answers (scale 1-4)?
Hi Nabila Benmalek Hope you are doing well. I would like to mention a No Code Data Visualization Tool for the purpose to get insights from your raw data. Hope you will like it. You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr. And if you are comfortable with Google Sheets, you can find https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr. This https://www.youtube.com/watch?v=DSt000BPhOg perfectly fulfill your case. ThanksRe: Using MS Forms as a pop-up survey for a website
Hi ayeh1017 Your question is interesting, will make a research on it and will share with you definitely. Right now I can share with you Excel and Office 365 add-in where you can visualize NPS survey result with beautiful charts with minimum efforts and in a more professional way. https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr You can find sample videos here. https://www.youtube.com/watch?v=TxkWv9yvkGo https://www.youtube.com/watch?v=yW3EjBDO-sM All the bestRe: Creating Sankey Diagrams
Hi Tom_By Hope you and your loved ones are doing well. I totally agree with you that "Sankey Diagrams seem to fit that bill perfectly". I would like to recommend "ChartExpo For Excel" add-in for Sankey diagram. Very easy to create chart and there is no coding (VBA) skill required. ChartExpo for Excel Add-In: https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr ChartExpo for Google Sheets Add-On: https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr For detail video: https://www.youtube.com/watch?v=DSt000BPhOg I hope it would fulfill your requirements. All the bestRe: Visualizing Year-over-Year Sales Data with Comparison Chart in Excel
I express my sincere gratitude for your assistance in this matter. I comprehend your explanation regarding the data transformation process. However, I kindly request a chart or visualization that aligns with the example provided in my initial inquiry. ThanksRe: Visualizing Year-over-Year Sales Data with Comparison Chart in Excel
Himathetes, Thank you for your reply and willingness to help. I've attached an Excel file with a sample spreadsheet that closely resembles my actual data. I've ensured that the file is in the standard .xlsx format and have removed any sensitive information. Please let me know if you have any trouble accessing or opening the file. I appreciate your time and look forward to your suggestions or methods that may be helpful for my data visualization. Thanks, QaiserVisualizing Year-over-Year Sales Data with Comparison Chart in Excel
Hello everyone, I have sales data for different products over multiple years, and I'm looking for the best way to visualize this data in Excel. Specifically, I want to create a comparison chart that displays: Year-wise sales in columns: Each year should be represented by a column. Product sales in rows or stacks within columns: The rows, boxes, or stacks should be scaled based on the sales figures for each product in that specific year. Linking products across years: There should be a visual connection (like a ribbon or thick link) between the same products across different years, helping to illustrate the increase or decrease in sales. I created a visual mock-up in MS Paint to help convey my idea of how I want to visualize the data in Excel. I'm aware that Power BI offers a Ribbon Chart that might achieve a similar effect. However, I'm looking for a solution within Excel. Could anyone suggest the best approach or chart type to accomplish this in Excel? If possible, please provide a step-by-step guide or any tips to achieve this visualization effectively. Thank you!Re: Microsoft Forms - Inverted Likert Scale
Hi commsmanger I attached sample charts created on survey data. Data refresh in the chart automatically as you change your data selection. I regularly create these charts with the following tool. Hope you will like it. You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr. And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr. Thanks Likert Scale Chart for survey data Few more variations to visualize NPS DataRe: Likert scale order of statements
Hi MarinJ1200 The Likert Scale Chart is considered the most suitable visualization for the given data format. The platform described below supports three distinct data formats, enabling the creation of a Likert Scale Chart in just a few steps. Additionally, it offers a rich set of customization properties, enhancing the flexibility and utility of the chart. I regularly create these charts with the following tool. Hope you will like it. You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr. And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr. Thanks Likert Scale Chart for survey data Few more chartsRe: Likert question on excel
Hi jfune1 I attached sample charts created on survey data. Data refresh in the chart automatically as you change your data selection. I regularly create these charts with the following tool. Hope you will like it. You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr. And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr. Thanks Likert Scale Chart for survey data Few more survey charts.Re: Filter by question in Pivot Table
HI darrenlow The Likert Scale Chart is considered the most suitable visualization for the given data format. The platform described below supports three distinct data formats, enabling the creation of a Likert Scale Chart in just a few steps. Additionally, it offers a rich set of customization properties, enhancing the flexibility and utility of the chart. I regularly create these charts with the following tool. Hope you will like it. You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr. And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr. Thanks Likert Scale Chart for survey data Few more chartsRe: Need help with my formula, please!
Hi jty1969 I attached sample charts created on survey data. Data refresh in the chart automatically as you change your data selection. I regularly create these charts with the following tool. Hope you will like it. You can check here for https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr. And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr. Thanks Likert Scale Chart for survey data Following 2 more charts for survey.Re: Forecasting
Hi Tisha, Hope you are doing well. I would like to recommend "ChartExpo For Excel" add-in for Sankey diagram to visualize financial analysis. Very easy to create chart and there is no coding (VBA) skill required. ChartExpo for Excel Add-In: https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr ChartExpo for Google Sheets Add-On: https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr ChartExpo for Power BI Add-On: https://chartexpo.com/utmAction/MTYrY29tbXVuaXR5K3BiK2NleHBvK1FKMTAwMCtTYW5rZXkr For detail video: https://www.youtube.com/channel/UCcZvZYtSyVfraYyWW-uUTTQ I hope it would fulfill your requirements. All the bestRe: Sankey Diagram with Power User
Hi Maddy, Hope you are doing well. I would like to recommend "ChartExpo For Excel" add-in for Sankey diagram. Very easy to create chart and there is no coding (VBA) skill required. ChartExpo for Excel Add-In: https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr ChartExpo for Google Sheets Add-On: https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr ChartExpo for Power BI Add-On: https://chartexpo.com/utmAction/MTYrY29tbXVuaXR5K3BiK2NleHBvK1FKMTAwMCtTYW5rZXkr For detail video: https://www.youtube.com/channel/UCcZvZYtSyVfraYyWW-uUTTQ I hope it would fulfill your requirements. All the bestRe: Pivot - Pareto
Hi Monja5 I attached a sample image of the Pareto chart created with pivot table data as you can see in the image attached. You can use it to create in https://chartexpo.com/utmAction/NCtNVEMreGwrUUorTVNPRlRDTVQr. And if you are comfortable with Google Sheets, you can find it https://chartexpo.com/utmAction/NCtNVEMrZ3MrUUorTVNPRlRDTVQr. Thanks
