Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Displaying cell data in a chart
Previous posts indicate a successfuly method for displaying data/text from a
cell into a chart. Following this procedure, I select the chart, press the equal sign, and select the cell, and then enter. The address of the sheet and the cell address are displayed after the equal sign. When I press enter nothing seems to happen. The data are supposed to display in the middle of the chart, but I do not get any display of the data. I am in a Pivot Table worksheet but did not directly insert a Pivot Chart. I used getpivotdata and created new cells for plotting into the inserted column chart using that data. I appear to be able to utilize all Excel charting funcgtions with these charts. Am I missing something? J. Austin |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Displaying cell data in a chart
Hi,
By any chance are you using xl2007? If so the type ='s does not work. You need to insert the textbox and then use the formula bar to enter the cell reference. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "J Austin" wrote in message ... Previous posts indicate a successfuly method for displaying data/text from a cell into a chart. Following this procedure, I select the chart, press the equal sign, and select the cell, and then enter. The address of the sheet and the cell address are displayed after the equal sign. When I press enter nothing seems to happen. The data are supposed to display in the middle of the chart, but I do not get any display of the data. I am in a Pivot Table worksheet but did not directly insert a Pivot Chart. I used getpivotdata and created new cells for plotting into the inserted column chart using that data. I appear to be able to utilize all Excel charting funcgtions with these charts. Am I missing something? J. Austin |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Displaying cell data in a chart
Andy,
Thanks for the quick response. Yes, I am using xl2007. And your solution worked great. Going to save me a lot of grief in updating a large number of charts automatically. Thanks again, J.Austin "Andy Pope" wrote: Hi, By any chance are you using xl2007? If so the type ='s does not work. You need to insert the textbox and then use the formula bar to enter the cell reference. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "J Austin" wrote in message ... Previous posts indicate a successfuly method for displaying data/text from a cell into a chart. Following this procedure, I select the chart, press the equal sign, and select the cell, and then enter. The address of the sheet and the cell address are displayed after the equal sign. When I press enter nothing seems to happen. The data are supposed to display in the middle of the chart, but I do not get any display of the data. I am in a Pivot Table worksheet but did not directly insert a Pivot Chart. I used getpivotdata and created new cells for plotting into the inserted column chart using that data. I appear to be able to utilize all Excel charting funcgtions with these charts. Am I missing something? J. Austin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Displaying hidden data on a chart | Charts and Charting in Excel | |||
Column chart not displaying some data points - Excel 2003 | Charts and Charting in Excel | |||
Displaying Chart Data ontop of Image | Charts and Charting in Excel | |||
Displaying data in bar form on a line chart | Charts and Charting in Excel | |||
chart displaying horizontal line for zero data | New Users to Excel |