value in Chart diagram

Copper Contributor

Hello Experts,


i receive 52 values from one site and I want to represent those values in a chart. How can I do it and which chart can I use it?

This will use  to compare with the result from another site. In total, there are 5 sites and I want to represent the weakest and the strongest areas.



2 Replies


To represent 52 values from one site in a chart, and then compare them with the results from other sites to identify the weakest and strongest areas, you can follow these steps in Excel 365:

Creating the Chart for One Site:

  1. Enter your data in an Excel worksheet. You should have 52 values for the first site.
  2. Select the range of your data.
  3. Go to the "Insert" tab in the Excel ribbon.
  4. Choose the type of chart that best represents your data. Common options include bar charts, line charts, or scatter plots. The choice of chart depends on the nature of your data and how you want to visualize it.
  5. A chart will be inserted into your worksheet based on your selection.

Comparing with Other Sites:

To compare the results from multiple sites, you can either use different colors for each site in the same chart or create separate charts for each site and place them on the same worksheet. Here's how you can do it:

Option 1: Using Different Colors in One Chart:

  1. In the same chart you created earlier, you can add data for other sites using different colors. Ensure that you include the 52 values for each site.
  2. Different colors will distinguish the data for each site in the same chart.
  3. You can add a legend to indicate which color corresponds to which site.

Option 2: Creating Separate Charts for Each Site:

  1. For each site, create a new chart following the same steps as mentioned earlier.
  2. Place each chart on the same worksheet but ensure they are not overlapping.
  3. Label each chart to indicate the site it represents.
  4. Use Excel's features to align and arrange the charts neatly on the worksheet.

To identify the weakest and strongest areas:

  1. You can add a data label to each data point in the chart to display the actual values. This will allow you to see the values more clearly.
  2. Review the charts for each site to identify the areas with the highest and lowest values.
  3. Compare the corresponding data points across different charts to identify which areas are consistently strong or weak across the sites.

The choice of the chart type depends on your specific data and how you want to visualize it. Bar charts are commonly used for comparing values across categories, while line charts show trends over time, and scatter plots can help you identify relationships between variables. You may want to experiment with different chart types to find the one that best suits your needs.

Since no one has replied to this for over a day and more, I entered your question in various AI's. The text and the steps are the result of the compilation of different AI's.


My answers are voluntary and without guarantee!


Hope this will help you.


Was the answer useful? Mark as best response and like it!

This will help all forum participants.

@NikolinoDE , thank, I will try a let you know, if it works.