Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Update Charts X-axis
I have a program with 76 charts. They all use the same range to get their
x-axis (dates). At the first of every month, I change the dates to show the upcoming month. The table shows the entire year, but we just view it one month (fiscal) at a time. The series is by rows, but could be changed to columns if necessary. I inherited this program. Currently I have to update each one of them manually (click on each and change their XValues). Is there a way I can update all of them at one time? Could vba be used to select and update each chart with me just selecting the range? I am no stranger to vba, but have done very little when it comes to charts. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Update Charts X-axis
Hi,
You can use a dynamic range to provide the xaxis label reference. http://peltiertech.com/Excel/Charts/DynamicLast12.html You might want to use VBA to apply the named range rather that do it 76 times. But once done updating should be automatic. Cheers Andy dbaggett wrote: I have a program with 76 charts. They all use the same range to get their x-axis (dates). At the first of every month, I change the dates to show the upcoming month. The table shows the entire year, but we just view it one month (fiscal) at a time. The series is by rows, but could be changed to columns if necessary. I inherited this program. Currently I have to update each one of them manually (click on each and change their XValues). Is there a way I can update all of them at one time? Could vba be used to select and update each chart with me just selecting the range? I am no stranger to vba, but have done very little when it comes to charts. Any help would be greatly appreciated. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charts won't update | Charts and Charting in Excel | |||
charts....x and y axis | Charts and Charting in Excel | |||
Charts don't update when data changes | Charts and Charting in Excel | |||
combing two bar charts to share one axis | Charts and Charting in Excel | |||
change axis info on radar charts | Charts and Charting in Excel |