Macro shows three seperate data ranges in line graph

**Ochimus** · 04-22-2015, 11:38 AM

Apologies if this has been answered before, but I couldn't find a solution.

Attached file Three Col Graph.xlsm has Macro that SHOULD create a line graph from data in Cols C. E and G

The Macro in the file creates the graph using data in ONE Column, but I can't find how to set the values to cover all three columns.

Please Login or Register  to view this content.

Any suggestions received gratefully

Ochimus

**Arkadi** · 04-22-2015, 11:59 AM

Hi,

Edit: now I think this might work..:

Please Login or Register  to view this content.

The problem was that you were trying to put all data into one series... when they are actually 3 separate data series. I would have used a loop but wanted to keep it simple to follow and close to original code.

**Ochimus** · 04-22-2015, 05:36 PM

Arkadi,

Many thanks for the solution. Obviously I was misled by the fact the when you create the graph manually you enter the three ranges together separated by commas.

I have now been asked to create a "Log Y" axis AND reverse them so the Data becomes the Y axis.

Which will clearly have to be topics for another thread - or two.

Ochimus