Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic updating for text boxes used on Charts
One of my supervisors has asked for me to design a new chart for an ongoing
project (that will be updated weekly), where a formula based on one only column of data (that is linked from another spreadsheet) is reflected on a Chart (currently) by creating text boxes and typing in the result. He would like this to be automatically done each time the master spreadsheet is updated. The primary info is: Level I 52 0.21 Level II 171 6.50 Level III 68 5.78 Level IV 8 1.55 The second column is the data linked from the master spreadsheet, and the second column is a fixed formula (i.e., b1*0.4%). My supervisor only wants the data shown on a bar graph, and the formula results as text on each bar. I've tried pasting the formula into the text box, and it won't accept it. I searched Microsoft's site, and on the internet, and haven't found a resolution as yet. I would appreciate any suggestions or assistance. Thank you! Morjana |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatic updating for text boxes used on Charts
Hi,
While viewing your window chart, go to formula area, type = go to your worksheet select your cell type enter back to your chart, position the Text Box where you want it to appear Each time your cell changes in your spreadsheet, the update is now automatic in your chart ... HTH Cheers Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Source Code in Charts | Charts and Charting in Excel | |||
Trying to get my questions answered again...updating charts in a w | Excel Discussion (Misc queries) | |||
Simultaneously updating Charts in Multiple sheets | Excel Worksheet Functions | |||
need a refresher: text boxes on charts that use relational formulas? | Charts and Charting in Excel | |||
Automatic Updating Charts | Charts and Charting in Excel |