Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
128
Text Labels on the X Axis in a Scatter Chart
posted

I've got data that is formatted in a table as follows, and am displaying it in a Scatter Chart in WinChart version 7.3.20073.38:

Date (Text), Index (Integer), Value (Double)
2007-01-20, 1, 182708.213068332
2007-04-20, 2, 191849.206636247
2007-07-19, 3, 181909.247938635
2007-10-17, 4, 193106.239361725
2008-01-15, 5, 186136.687476901
2008-04-14, 6, 181598.738009246
2008-07-13, 7, 182911.470058264
2008-10-11, 8, 180885.534667417

The scatter chart is using the second column (Index) for the X Axis, and the third column (Value) for the Y Axis. The index column is used for the X axis so that I may use custom code to calculate and graph the best-fit polynomial on the chart. The first column is a text column, not a date column, representing the date that the value was taken.

I'm getting a chart as shown in the attached screen shot, but I would like the X axis labels to use the first text field in each row, instead of the second field. I've tried setting the X Axis label's ItemFormat to <ITEM_LABEL>, but this only results in the X Axis being labeled with a bunch of literal "<ITEM_LABEL>" strings.

How would I go about having the text fields show up as X Axis labels?