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
Correct - XY Scatter charts are not supported for pivot charts.
In the attached version, I used the FILTER function to split the data for dtx=0 and dtx=1, then created a XY Scatter chart from the two ranges.
Thanks HansVogelaar and what if the 3rd Variable txNumber also comes into picture( Chart-2)?
Br,
Anupam
See new version
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.
