O
ooievaar6
To continue the analogy:
The four columns of numbers represent the different activities of the
fruit eg. in stock, on order, sitting on the shelf, sitting by the
counter. The first two columns of numbers are in thousands, and so get
plotted against the left y-axis. The last two columns of numbers are
in tens, and so get plotted the right y-axis.
The month column is plotted along the x-axis.
Is the answer still a PivotTable with an associated PivotChart?
Rgds,
Ooi
The four columns of numbers represent the different activities of the
fruit eg. in stock, on order, sitting on the shelf, sitting by the
counter. The first two columns of numbers are in thousands, and so get
plotted against the left y-axis. The last two columns of numbers are
in tens, and so get plotted the right y-axis.
The month column is plotted along the x-axis.
Is the answer still a PivotTable with an associated PivotChart?
Rgds,
Ooi