graphing a chart in VBA, showing series legends on the chart

**Lifeseeker** · 02-08-2012, 03:33 PM

Hi guys,

I'm trying to generate a graph in VBA, but am having some difficulties getting the series legend on the graph.

Can anybody help?

Please Login or Register  to view this content.

So I think that for loop is what I want shown on the x-axis on the graph, but months are not showing when run.

Any ideas?

**Lifeseeker** · 02-08-2012, 08:07 PM

Is anybody able to assist me on this?

I'm almost there...

**Andy Pope** · 02-09-2012, 07:21 AM

The chart type xy-scatter only displays numeric values on the axes.
If you want months on the x axis you will need to use a Line chart.

Please Login or Register  to view this content.

If you want to have the months in the legend you will need to plot each value as a series rather than a data point in a single series.

**Lifeseeker** · 02-09-2012, 09:44 AM

thanks and it worked.

It does take me some time to read through lines of code to understand

Please Login or Register  to view this content.

what does this code block do? If I got rid of it, nothing was changed. Is it normal?

Thanks

**Andy Pope** · 02-09-2012, 10:01 AM

If the activecell is in a block of data the add chart will attempt to use that data in the chart. The loop removes any series added by this action.

**Lifeseeker** · 02-09-2012, 10:24 AM

when you say the activecell is in a block of data, what do you mean by a block of data? You mean if those fiscal months are in all in one cell?

**Andy Pope** · 02-10-2012, 06:59 AM

I mean if the activecell contains data then excel will try and use that cell and the adjacent cells to populate the chart. If the cell is empty the chart will be empty.

Try it. Select an empty cell and press F11 to create a chart.
Now select a cell that has data and press F11.