Data table without graoh details
 

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200806/1

Data table without graoh details
 

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
_______


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:859cbac088aae@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200806/1

Data table without graoh details
 

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

Jon Peltier wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200806/1

Data table without graoh details
 

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
_______


"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:85a75e8c171b6@uwe...
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

Jon Peltier wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200806/1