Forum Discussion
Charts- doubt_1
Dear Experts,
I have a Data as below , in worksheet named "Data" and need to create charts as in Worksheets "Chart-1" and "Chart-2",
Could you please help share on how to do that, I tried Pivot, then Scatter-plot can't be used, is there some limitation?
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
9 Replies
I see Hans already replied but I took a slightly different approach and expanded on the existing data table.
I did convert to table but you could do the same/similar without the conversion
Basically instead of FILTER I did new columns that replaced 'wrong' values with NA():
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
