Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

After plotting Stacked Column Graph, e.g from the following data.
Here, %Share in column F is not the actual data, but the calculated X center positions of columns
using the Set Column Formula: i

 i==1?(col(C)[i]/2):(col(F)[i-1])+(col(C)[i-1]/2)+(col(C)[i]/2) .


The actual data is presented as the column width stored in the column C ("w").

To set the column width from a dataset, set the dataset to Width field in Spacing tab in Plot Details.
You also need to set both Scaling Factor and Gap between Bars to 0 to 0, which is the new feature to indicate the column w or symbol size data from worksheet is in the same unit as the X axis.

The graph will turn into the following:

...