2
$\begingroup$

In that graph, I want to show the two values and the error percentage from the comparison between two values. I am using microsoft excel.

can anyone give me any idea which best graph for this case? Thank you

$\endgroup$
2
  • 1
    $\begingroup$ If you really only have two values, I don't think a graph is necessary. Just the values themselves in a table + the error % should be sufficient. $\endgroup$
    – am304
    Feb 9 '18 at 11:09
  • $\begingroup$ but my professor want it in a graph instead, I have four cases to be compared, but each case I want to compare the two values from measurement and analysis, have any idea? $\endgroup$ Feb 9 '18 at 11:16
4
$\begingroup$

Based on the discussion in comments, you probably want to use a bar chart combined with a line for the error. Have a look at Create a combination chart for more details.

In your case, and using dummy data, it would probably look something like this:

  • Data in Excel

enter image description here

  • Resulting combination graph

enter image description here

$\endgroup$
3
  • $\begingroup$ I am not sure I understand this graph, What I want is the information error percentage between two values for each case, but inside the graph it include 4 cases. I tried to make this graph, but it seems like the excel consider for all cases together.. $\endgroup$ Feb 9 '18 at 11:52
  • 2
    $\begingroup$ Ah, OK. I think I understand now. I have updated my answer based on your comment. $\endgroup$
    – am304
    Feb 9 '18 at 12:24
  • $\begingroup$ Thanks a lot.. now I think you are very right... thank you so much!!! it is very helpful.. $\endgroup$ Feb 9 '18 at 12:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.