Forum Discussion
Charts- doubt_1
You can either go to 'Select Data' and click Add Series and select the X and Y ranges to add, or a trick I like to use is select those 2 columns and COPY and then right click on graph and hit paste special, then you make sure New series, Columns, and X Values in First Column are selected and hit OK
Thanks HansVogelaar and what if the 3rd Variable txNumber also comes into picture( Chart-2)?
Br,
Anupam
Hi HansVogelaar , Sorry for Stupid questions :( , but please could you educate me on how you achieved this chart from the Column H,I,K,L(Filter Function is understood) ?
please share the steps , if possible.
Br,
Anupam
Click on the chart.
On the Chart Design tab of the ribbon, click Select Data.
Select a Series and click Edit.
You'll see how the ranges for the x-values and y-values have been chosen.
What , I did is , so Clicked H & I, then Insert Scatter-plot and got (3) , but not sure after this how to achieve what you prepared.
Br,
Anupam
You can either go to 'Select Data' and click Add Series and select the X and Y ranges to add, or a trick I like to use is select those 2 columns and COPY and then right click on graph and hit paste special, then you make sure New series, Columns, and X Values in First Column are selected and hit OK
