If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Loss of referenced data (Titles) when upgrading from Excel 2000 to2007
I have many instances of the same type of issue, so will provide one
example. A solution for one should fix all... I have a chart data sheet that 20+ charts reference every month. When creating the titles for the charts, it was necessary to refer to the month the chart represents. This information is located in one cell on the data sheet. In Excel 2000, all one had to do was have the focus on the chart, type in "=" and reference the cell the date is in. The data in the cell would then show on the chart as basically a text box and I could manipulate other words around it to make a title for the chart dynamic. Excel 2007 has deleted all of this type of cell reference on my charts. What alternatives do I have for placing a dynamic text box which references a cell onto a chart?? This is a huge issue, so am hoping someone has some advice. Thanks in advance for any help you can provide!! Rita Brasher Project Engineer FedEx Express / Global Trade Services MIS&T |
#2
|
|||
|
|||
Loss of referenced data (Titles) when upgrading from Excel 2000to 2007
Maybe it has been killed as paert of a conversion between file formats,
but 2007 certainly supports the sort of thing you are talking about. If you select the chart title box, or an axis label for example, you can simply type in the formula bar what they should display, for example ="Sales figures for month of "&A1&" "&B1&" (USD Millions)" (or something simpler pointing to a single cell that does the hard work for you instead). Hope this helps Adam On 18/02/2010 19:54, Rita Brasher wrote: I have many instances of the same type of issue, so will provide one example. A solution for one should fix all... I have a chart data sheet that 20+ charts reference every month. When creating the titles for the charts, it was necessary to refer to the month the chart represents. This information is located in one cell on the data sheet. In Excel 2000, all one had to do was have the focus on the chart, type in "=" and reference the cell the date is in. The data in the cell would then show on the chart as basically a text box and I could manipulate other words around it to make a title for the chart dynamic. Excel 2007 has deleted all of this type of cell reference on my charts. What alternatives do I have for placing a dynamic text box which references a cell onto a chart?? This is a huge issue, so am hoping someone has some advice. Thanks in advance for any help you can provide!! Rita Brasher Project Engineer FedEx Express / Global Trade Services MIS&T |
Thread Tools | |
Display Modes | |
|
|