| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Chart Source References
I run a report on a weekly basis and would like the values in the chart to be
dynamic, so that I as I up-date the date each week the new data is added and the data that is the oldest drops off the chart values. I also need to do the same with the Category (X) axis labels: Is this possible and if so how do I start Values. =Sheet1!$AA$62:$AA$133 Category (X) axis labels: =Sheet1!$A$62:$A$133 Thanks Nick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic references in diagram source data? | Excel Discussion (Misc queries) | |||
| How do I automatically update chart source data links for moved fi | Charts and Charting in Excel | |||
| In mixed bar and line chart. I cannot change one of my source da. | Charts and Charting in Excel | |||
| In mixed bar and line chart. I cannot change one of my source da. | Charts and Charting in Excel | |||
| Chart disappears when source data cells are hidden | Excel Discussion (Misc queries) | |||
Threaded Mode
