Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Label Update
I have a series of data which i add one line everyday, and I plot a graph
that is linked to this series. I want to display the value of the last cell plotted on the graph, and to do this now, i'm adjusting manually (right click, data lables and click on value) my q is when i add a line, can the graph be automatically updated to display the last cell value? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Label Update
Hi,
If you have already created values for your data series, then for any additional line you can just select the cell and drag and drop in to the chart area. All properites you have assigned will be applied to any additional data values. Note: You can add more column labels and values and drag and drop inside the chart area. Challa Prabhu "IK" wrote: I have a series of data which i add one line everyday, and I plot a graph that is linked to this series. I want to display the value of the last cell plotted on the graph, and to do this now, i'm adjusting manually (right click, data lables and click on value) my q is when i add a line, can the graph be automatically updated to display the last cell value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide the data label for a data table in a chart | Charts and Charting in Excel | |||
add a data label | Charts and Charting in Excel | |||
How to rezize data label box in pie charts (label wraps to two lin | Charts and Charting in Excel | |||
data label | Excel Discussion (Misc queries) | |||
how to remove label formatting (eg label to number) | Excel Worksheet Functions |