-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Can you show a table on a chart?
- Thread starter spurs
- Start date
brian.wethington
Well-known Member
- Joined
- Jul 20, 2006
- Messages
- 1,739
You mean a table of values used for the chart? If so it is in the Chart Options
Right click the chart
select Chart Options
Select Data Table tab
check the Show Data Table
If not can you explain?
Right click the chart
select Chart Options
Select Data Table tab
check the Show Data Table
If not can you explain?
Upvote
0
spurs
Active Member
- Joined
- Oct 18, 2006
- Messages
- 479
- Office Version
- 2016
- 2013
- 2010
- 2007
- 2003 or older
- Platform
- Windows
Brian
Not the table of values that creates the lines on the chart. But a different table - for example a table that may show range, period, average values of the data on the chart.
Not the table of values that creates the lines on the chart. But a different table - for example a table that may show range, period, average values of the data on the chart.
Upvote
0
indiantrix
Well-known Member
- Joined
- Oct 17, 2002
- Messages
- 943
You might try this:
1. Select your range of cells from desired table area
2. Hold down the Shift Key, click Edit/Copy Picture
3. Click OK.
4. Go to desired Chart, Edit/Paste, then position/size as needed.
5. Just a picture, but could be worth 1,000 words!
Anyone else?
/s/ Larry
1. Select your range of cells from desired table area
2. Hold down the Shift Key, click Edit/Copy Picture
3. Click OK.
4. Go to desired Chart, Edit/Paste, then position/size as needed.
5. Just a picture, but could be worth 1,000 words!
Anyone else?
/s/ Larry
Upvote
0
steve case
Well-known Member
- Joined
- Apr 10, 2002
- Messages
- 823
Thanks IndianTrix - that is one cool trick,
Upvote
0
brian.wethington
Well-known Member
- Joined
- Jul 20, 2006
- Messages
- 1,739
It pastes to the chart when I follow the steps. By the way, nice trick IndianTrix. If you have the chart selected and it does not paste there where does it paste? now on the update question. Perhaps you could do some VBA with some event code to get it to update. Just an idea. But first you have to get the paste working. Then work the other out.
Upvote
0
Datsmart
Well-known Member
- Joined
- Jun 19, 2003
- Messages
- 7,985
It will update if you use the Camera Tool to copy your data table.
How to use Camera Tool:
http://www.exceluser.com/solutions/traffic.htm
choose Tools, Customize in Excel. In the Commands tab choose the Tools category. In the list of commands at the right side of the dialog box you'll find the Camera icon slightly below the mid-point of the list. Click and drag the icon to a convenient toolbar in your Excel workspace.
How to use Camera Tool:
http://www.exceluser.com/solutions/traffic.htm
choose Tools, Customize in Excel. In the Commands tab choose the Tools category. In the list of commands at the right side of the dialog box you'll find the Camera icon slightly below the mid-point of the list. Click and drag the icon to a convenient toolbar in your Excel workspace.
Upvote
0
