Thread: Line Chart formatting

I am trying to create a line chart within excel that graphs mpg’s per fill up. I want to format the line so it appears one way when the drive type for the tank is “highway” and another way when the drive type for that tank is “city”. I was able to reproduce what I’m after manually but need to find a way to reproduce this automatically.

I have attached a spreadsheet detailing what I am after. Any help or suggestions would be greatly appreciated!

Thanks
Impala096

Hi there,

I know I way to do it through lists and a visual basic macro, but would that help you?

If so I will create the macro and post the solution, otherwise I don't know how to get this done...

J.

Hi Jevni,

That would be great if you wouldn't mind. I need all the help i can get! I've worked on it a little bit farther and i've pretty much automated the process but now the spreadsheet is running very slowly when entering data due to the number of formulas needed to create the proper formatted source data for the chart to reference.

I'll attach my latest spreadsheet for anyone interested.

Thanks
Impala096