ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Selecting series in a chart based on a range and manual inputs (https://www.excelbanter.com/excel-discussion-misc-queries/237329-selecting-series-chart-based-range-manual-inputs.html)

Tigerxxx

Selecting series in a chart based on a range and manual inputs
 
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!



All times are GMT +1. The time now is 08:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com