How to use 2 sets of Data in a chart

[philion_91]

Hi,

I'm trying to create a bar chart with 2 sets of data, but I can't get what I want.

So far, I have create the chart with the first set of data (A:B), but I can't find a way to add the second data sets. (D:E)

I have attached my spreadsheet.

Your help your be greatly appreciated.

[PaulM100]

It won't be easier to add one column containing your courses, in A for example, then in B "Note des competences" and in C "Note de evaluation" or whatever and then create a chart based on that?
One way would be to select both sets of data, then Insert - Recomended Charts and select a Type. But it will all only the values that are found in both sets. "Sens politique" won't be added

[MrShorty]

I find that it is almost always easier to do this if I combine the data into a single table rather than try to use two different tables to make one chart (especially for charts that use a category axis). If this data is "pivoted" or something from a larger data set, I would recommend thinking about how you are bringing this data into Excel and make changes at that stage. Working from the file as is, I would:

1) Select A2:A6 and copy into I2:I6
2) Select D3,D4,D6 and copy into I7:I9 (later I discovered the trailing spaces in the text n column D. I would edit the entries in column D to remove the trailing space).
3) Use a lookup function to pull the data from each table into this table. VLOOKUP() help file: https://support.office.com/en-us/art...8-93a18ad188a1 In J2 =VLOOKUP($I2,$A$2:$B$6,2,FALSE) and copy down to J9. I would not worry about the N/A errors.
4) Copy J2 into K2. Edit formula to use $D$2:$E$6 as the lookup_table. copy down to K9
5) Select I2:K9 and insert chart. Format chart as desired.