Hi,

I am using Excel for ages and I noticed that in the case, I have to put
numbers in the legend, I have to click and select each of them separately
every time. Is there a faster way?

This is an example of "Testing results" chart (I need years on X-axis and
test numbers in the Legend)

test no.\year    2006    2007    2008

213345          1231    1311    1366

213367          1235     1333    1335

In Excel 2007:

   I select everything and insert a Column Chart. Excel puts test numbers
(and even years) as columns. Wrong!?

   I select data only and create a Chart. On the chart I use right click,
"Select data" and for each "Legend Item - series name" I click and select
appropriate cell. Too much clicking (this is a simple example, we have more
than 10 test no. in the chart)!?

I know I could put special sign ( ' ) in front of every test number (Excel
then interprets it as a text) and it would work, but I don't want to,
because we use numbers for that. So how to put or insert numbers in the
legend of the chart as fast as possible?

Thanks

Mitja