ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a combination chart and table with different data. (https://www.excelbanter.com/charts-charting-excel/112392-how-do-i-create-combination-chart-table-different-data.html)

betsystone

How do I create a combination chart and table with different data.
 
I am using Windows XP, and Microsoft Excel 2003. I have been asked to create
scorecards with charts displaying rates graphically, and an attached table
underneath with numerator and denominator data. The combination graphs in
the custom charts try to graph and display all the data. Can I create a
combination chart with the rates graphically displayed and the underlying
numerator/denominator data presented in a linked table underneath the chart?
Or do I need to create the graph and table separately?

Jon Peltier

How do I create a combination chart and table with different data.
 
You would do better to make a separate chart and table, because chart data
tables are restrictive in what they can contain and how they can be arranged
and formatted.

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


"betsystone" wrote in message
...
I am using Windows XP, and Microsoft Excel 2003. I have been asked to
create
scorecards with charts displaying rates graphically, and an attached table
underneath with numerator and denominator data. The combination graphs in
the custom charts try to graph and display all the data. Can I create a
combination chart with the rates graphically displayed and the underlying
numerator/denominator data presented in a linked table underneath the
chart?
Or do I need to create the graph and table separately?





All times are GMT +1. The time now is 10:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com