ColHdgs=Years show up as series not as legend labels

[ExcelProf]

Hi Bernard - thanks for your helpful info.

There's no way around it.
We'll modify the macro to insert a blank column before th
year-headings and data series, and input a row label for the dat
series.

You detailed responses and assistance is surely appreciated.
ExcelProf
===========
Bernard Liengme
Guest

Posts: n/a
Re: ColHdgs=Years show up as series not as legend labels
If I put the years in A1:A4 and the data in B1:B4, select A1:B4 an
make a
chart then I get a chart with two data series. Just as you say, th
years
are not used as the x-category values. Excel needs a blank heading i
the
values are numeric and you want to make a category-type chart (anythin
but
XY)

But if I insert a column (now the years are in A2:A5 and the number
in
B2:B5) and type the word Data in B1 (BUT LEAVE A1 BLANK), select A1:B
and
make chart, I get what we want.

I could have put the years in A2:A5 and the numbers in B2:B5 with
suitable
heading in B1.

Hope this helps

 

[Jon Peltier]

Excel Prof -

Here's a suggested revision to your technique.

Manually charting: Select the values only, not the years, start the chart wizard. In
step 2, click on Series tab, click in blank X values box, and select the range with
the years.

VBA charting: only use values range in SetSourceData, then with seriescollection(1),
set the .XValues to the range with the years.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______