• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Updating of Excel charts in Office 2010

Y

yudhishjain

New Member
Hi, I was earlier using Office 2003 and recently have migrated to Office 2010. For updating the charts in 2010, (I have around 4-5 data series in every chart) I have to edit each data series and use the F2 button to change the range of the series. The process was much simpler in 2003. What is the process of updating the X-Axis, do i need to change the x-axis series in every data series? Could you help me out with some shortcut?
 
Yudhishain


The use of Dynamic formulas or named formula are ideal for this task

Try using the google search box top right of this page first
 
Yudhishjain


Why not suggest changing the chart for the client and see what his response is? You might be surprised at their response


You could also write a macro to scan through each chart and reset the x-axis range
 
You must log in or register to reply here.
Back
Top