Forum Discussion
Re: Charts- doubt_1
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.
6 Replies
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.
