Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I display a formula calculation in plot area of a chart?
I want to add a text box in the chart that returns the value from a formula
that was entered on the data page. The formula value is not related to any series value. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I display a formula calculation in plot area of a chart?
WiseGuyOne:
You need to build your text expression in a cell, then insert that expression to the chart. First, to build your text expression: 1. Select your cell 2. Enter = first to let Excel =know you are adding a formula 3. You can now enter text within quotes and cell values .. here's an example =" Yesterdays average temperature was " & sheet1!$a$3 Note that the & is used to add elements to your text string 4. If you need to format your cell value, use something like Text(sheet1!$a$3, "0.0%") Second: Once you have your text string working the way you want 1. Select your chart 2. Type = in formula bar 3. Select cell with text string 4. Press enter 5. Unselect chart The text string should now be on your chart. Move it to desired location, format as needed. When the formula value changes, the text string will update. Kelly http://processtrends.com "WiseGuyOne" wrote in message ... I want to add a text box in the chart that returns the value from a formula that was entered on the data page. The formula value is not related to any series value. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you show plot area only-no chart area | Charts and Charting in Excel | |||
Resize plot area in a chart area | Excel Discussion (Misc queries) | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
is it possible two different colours in a chart plot area ? | Charts and Charting in Excel | |||
Resize chart area without resizing plot area | Charts and Charting in Excel |