Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dynamic references in diagram source data?
Have encountered problems when copying and pasteing diagrams and their source
data areas. I wish to exclude the $ signs in the source data formulas in order for the diagrams to retrieve data from different areas in the same spreadsheet. This however seems impossible because excel automatically reinsert the $ signs when I manually remove them from the source data formulas. Any thoughts? Thanks. -- Olzki |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Formula to display pivot table source data | Excel Worksheet Functions | |||
Using Excel workbook as data source for word mailmerge | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Formulas in source data | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |