Updating category axis excel

allows setting the category axis labels, axis options and formatting the axis.

The axis formatting is formed by number format, font settings, fill settings, line style settings, line color settings, shadow settings, 3D-format and alignment settings.

// Format category X axis Excel Axis xls XAxis = xls Chart.easy_get Category XAxis(); xls Line Color Format()Line Color(Color.

Steel Blue); xls Line Style Format()Dash Type(Line Style Format.

Because Western cultures are used to seeing time progress from left to right, you are likely to choose a chart where the axis moves from left to right—whether it is a column chart, line chart, or area chart.

If you have only a few data points, you can use a column chart because they work well for 4 quarters or 12 months.

Line charts can be designed to show only the data points as markers or data points can be connected with a straight or smoothed line.

I have a data plot chart (basic xy chart), that uses a dynamic data range, and automatically adjusts the scaling based on current data. To repeat the problem, try typing values into the table 1 at a time.

However, if you have say 28 data points defined, and -paste- 12 more values, bringing the total to 40, the max Cat Scale variable correctly calculates the value as 40, but the assignment .

Maximum Scale = max Cat Scale has no effect on the graph whatsoever.

Everything works perfectly as long as I am adding values to the named range 1 at a time, or deleting multiple values. You'll notice that the "Data Plot" will update as expected.

If, however, I -paste- multiple values into the range, the chart will not assign the new value to the Axes(xl Category). The variable max Cat Scale is being calculated correctly according to the watch set, but . Note, the category axis should only update for every 10 data points (this is by design).

Leave a Reply