Forum Discussion
M F
Dec 29, 2017Copper Contributor
scatter chart
For a line chart my horiz axis label range is: $A$82:$A$2000. The values in that range are dates. The axis type is a text axis.
I am converting the chart to a scatter chart, and I want the hori...
- Dec 29, 2017I found my own answer. Very simple. After converting to scatter chart, just delete the chart's horiz range info, leaving the field blank. The axis then magically populates with the desired integers.
M F
Dec 29, 2017Copper Contributor
I found my own answer. Very simple. After converting to scatter chart, just delete the chart's horiz range info, leaving the field blank. The axis then magically populates with the desired integers.