Selecting series in a chart based on a range and manual inputs

T

Tigerxxx

Hello,

I am plotting a chart of 12 numbers on the Y axis.
8 of the numbers are in a range a1:a8.
Remaining 4 numbers are manual.

Hence I would need to select the values in the series for thechart as
something like:
(a1:a8,num1,num2,num3,num4)
However I am not getting this syntax correct.

Any ideas how I can write this in the correct syntax?

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trendline Not Appearing In Chart Problem ? 0
setting scale on chart automatically 1
Input a Value to Lookup the Data Series for a Chart 5
Using Range names in selecting chart series. 1
Scatter Chart 0
use xlup and offset in a range of cells 1
Chart question - how to display 3 series as a bar chart and oneseries as a line 1
Employee Schedule not plotting properly - chart type / data series not correct 0

Top