Coding⏱️ 4 min read📅 2026-06-15

How to Fix: Excel error bars based not on the graph data, but a separate set of error measurement data

Excel error bars based on separate error measurement data

Quick Answer: Use the Error Bar option in Excel's chart tools and input your own error values from a separate sheet

📋 Table of Contents

  1. 💡 Why You Are Getting This Error
  2. 🔧 Proven Troubleshooting Steps
  3. 💡 Conclusion

Error Bars Not Calculated from Data Series Affecting Graph Accuracy

This issue can be frustrating when trying to accurately represent data with error bars, but don't worry, we have you covered. In this guide, we will walk you through the steps to create a bar graph with error bars based on separate error measurement data.

💡 Why You Are Getting This Error

  • The error occurs because Excel's built-in error bar calculation method relies on the data series itself, rather than external error measurements.
  • This can lead to inaccurate representation of data and incorrect conclusions drawn from the graph.

🔧 Proven Troubleshooting Steps

Using Power Query to Create Custom Error Bars

  1. Step 1: Step 1: Select the data sets containing average values and error measurements, then click on 'Data' > 'From Table/Range' to create a new query.
  2. Step 2: Step 2: In the Power Query Editor, add a new column for each data set by clicking on 'Add Column' and selecting 'Average' or 'Standard Deviation' depending on your error measurement type.
  3. Step 3: Step 3: Create a new table with the same structure as your original data, but with the custom error bars. This can be done by copying the average values into one column and the error measurements into another.
  4. Step 4: Step 4: Go back to your original data set and create a new column for each data point containing the corresponding error bar value from the custom table created in Step 3.
  5. Step 5: Step 5: Use the 'Insert' tab > 'Bar Chart' to create a bar graph with error bars. Select the new column as the value range for the bars, and choose the correct error bar type (whiskers extending up and down or right and left).
  6. Step 6: Step 6: Format the chart as desired to ensure accurate representation of data.

Using Custom Formulas in Excel

  1. Step 1: Step 1: Select the data set containing average values, then go to 'Formulas' > 'Define Name'. Create a new named range for the average value column.
  2. Step 2: Step 2: In another cell, use the formula `=AVERAGE(B:B)` (assuming B:B contains error measurements) to calculate the custom error bar value. Copy this formula down for each data point.
  3. Step 3: Step 3: Use the 'Insert' tab > 'Bar Chart' to create a bar graph with error bars. Select the new column as the value range for the bars, and choose the correct error bar type (whiskers extending up and down or right and left).
  4. Step 4: Step 4: Format the chart as desired to ensure accurate representation of data.

💡 Conclusion

By following these steps, you should now be able to create a bar graph with error bars based on separate error measurement data. This will provide an accurate representation of your data and help draw correct conclusions from the graph.

Did this fix your problem?

If not, try searching for specific error codes.

🔍 Search Error Database

❓ Frequently Asked Questions

🛠️ Related Fixes

How to Fix: Stuck in tutorial hell after 4 years: How do I b

Fix Stuck in tutorial hell after 4 years: How do I bui. Practice build

How to Fix: Trying to sync mutliple audio tracks to a movie

Fix Trying to sync mutliple audio tracks to a movie bu. Consider using

How to Fix: Failed to merge latest branches from upstream re

Fix Failed to merge latest branches from upstream repo. Try running 'g