Data Table Disconnected from Chart

Question

I have one spreadsheet where the data table is seamlessly bound to the chart. I have another spreadsheet where the data table is detached (separated) from the chart. Is there a way to control this behavior?

Answer 1

Does anyone have any ideas on how to control this graph behavior? I have the two charts in two different workbooks that behave differently.

Thanks

Answer 2

here is a sample image from the two different spreadsheets. The top is from a workbook where the data table is disconnected from the chart and the chart has its own axis.

The bottom image shows a portion of a chart from a second workbook that has the data table connected to the graph portion of the chart.

How can I control which way the data table is displayed?

Thanks,

Answer 3

Hi,

Thank you for replying.

Refer this link for more information about uploading the screenshot:

http://answers.microsoft.com/en-us/windows/forum/windows\_7-security/how-do-i-post-a-screen-shot-on-this-forum/c86de820-c620-401c-a804-9f6337cd3053

Thank you.

Answer 4

Thankyou for your reply. Is it possible for me to send you an image? It would show one chart in one sheet that has the data table connected to the graph and a second chart where the data table is not connected. I do not understand why one worksheet displays the data table and graph differently. I would like to know how to control it so all my charts look the same.

Answer 5

Hi,

Thank you for posting this question.

As I understand you are trying work with the Excel files with Charts. I would need more information to help you better.

1.Please elaborate ‘I have another spreadsheet where the data table is detached (separated) from the chart. Is there a way to control this behavior?’

2.What are you trying to accomplish between these two workbooks?

Provide us the exact steps you are following and the results expected to help you better.

Thank you.