Help with formatting and Index Formula

There were two things - you had #REF occurring twice on each chart, and the heading was obscuring one of the values on both charts. In the first case I just clicked on the chart, then right-clicked and chose Select Data, then just deleted the #REF errors in the list (for each chart). For the second item, I clicked on the chart body and then dragged it down so that the top value was no longer obscured. Actually, I also changed the colours for both headings.

Hope this helps.

Pete

It's helped out a lot. Is there a way to make the charts only apply to ME or EE? So I can have just 3 points on either chart?

Instead of getting the data directly from your table, you could use two columns elsewhere to supply the data to each chart - formulae in those columns would pick up the data for either EE or for ME.

Hope this helps.

Pete