Help with Excel Chart 1

[G12Consult]

Hi,

I have plotted points on a chart (see attached spreadsheet), however I need the labels on the X axis to be A, B, C, D, E, F, G, H, I, J instead of 1 - 10.

1 - 10 has been used for dummy purposes only to plot the dots correctly.

Thanks

 

[SkipVought]

Hi,

I re-formated your chart data in the YELLOW area.

Used a Line chart with markers. Then removed the lines for all except budget.

Took less than 15 min.

BTW, you never responded to my solution in your SUMPRODUCT thread.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[G12Consult]

Thank Skip,

I am sure I tried laying out the data that way but couldn't get it to work.

Thank you works perfectly!!

And in regards to the SUMPRODUCT query, my apologies, your solution worked there as well.

Thanks