Data table without graoh details

[BNT1 via OfficeKB.com]

hi

I am using a 100% stacked column graph to show the details of % late against %
on-time delivered, for each week. To obtain these figures I had the, total
delivered and late delivered volumes and did the necessary sums.
Q. how do I show the late and delivered volumes as well as the precentages
in the Data Table below the chart, but only show the required 100% stack
chart for % late against % on-time
Help appricaiated

Regards

Brian

 

[Jon Peltier]

You could format the unwanted series so as to hide them in the chart (no
border, no fill).

Or you could use the worksheet space around the chart, which has much more
flexible formatting and data capabilities than a chart's data table.

- Jon

 

[BNT1 via OfficeKB.com]

Thanks Jon

I understand your first point, however, would this not keep the chart spread
out, owing to the other columns hiden?

Would you be able elaborate further on your secound solution, as this looks
more inviting ! or perhaps a web site for guidence

regards

You could format the unwanted series so as to hide them in the chart (no
border, no fill).

Or you could use the worksheet space around the chart, which has much more
flexible formatting and data capabilities than a chart's data table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

hi

[quoted text clipped - 12 lines]

Brian

 

[Jon Peltier]

Excel's data tables are really not very flexible. I never use them. If I
need a table to accompany a chart, I create it in the cells below or next to
the chart. I can decide what data to show, how to format it, etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

Thanks Jon

I understand your first point, however, would this not keep the chart
spread
out, owing to the other columns hiden?

Would you be able elaborate further on your secound solution, as this
looks
more inviting ! or perhaps a web site for guidence

regards

You could format the unwanted series so as to hide them in the chart (no
border, no fill).

Or you could use the worksheet space around the chart, which has much more
flexible formatting and data capabilities than a chart's data table.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

hi

[quoted text clipped - 12 lines]

Brian