2

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

Cindy.Karina9
  • 187
  • 1
  • 13
  • 1
    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. – am304 Feb 09 '18 at 11:09
  • 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? – Cindy.Karina9 Feb 09 '18 at 11:16

1 Answers1

4

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

am304
  • 1,816
  • 12
  • 22
  • 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.. – Cindy.Karina9 Feb 09 '18 at 11:52
  • 2
    Ah, OK. I think I understand now. I have updated my answer based on your comment. – am304 Feb 09 '18 at 12:24
  • Thanks a lot.. now I think you are very right... thank you so much!!! it is very helpful.. – Cindy.Karina9 Feb 09 '18 at 12:31