Reference Line in Bar Chart - Manual Points

[joeybird]

Hiya

I wish to add a reference line in a bar chart.

I have found how to do this, but I wish to add a number of values - points on it manually.

not just e.g 300 straight across the chart.

on the bar graph I have number of pupils attending after school club per month,

but each month has a different target number.

how would i go about this please?

Kind Regards

Joeybird

[joeybird]

Hiya

sorted , thank you using your example above needed

LOAD

    SetNumber,

    "Month",

    'SetNumber' as ChartDim

FROM [lib://C:/SetNumbersRefLine.xlsx]

(ooxml, embedded labels, table is Sheet1);

Thanks all xxx

Kind Regards

Joeybird