Dynamic Scaling



  • 1. Work week holiday for different countries
    Is it possible to refer to a holiday list somewhere in my windows installation when I work with the function =WORKWEEK? If not, can I collect the holiday lists for different countries from Microsoft webpage somwhere?
  • 2. Incorrect Data Labels on Column Chart
    Hi, I'm having problems with certain data labels on columns within a chart, where the column reflects the correct data, but the data label contains the incorrect value. The value is the previous value of the chart before the data series were changed. Here's some background info that may or may not help explain why this is happening. I started with a worksheet containing 10 charts (5 line and 5 column), which worked great. This worksheet served as a template for 9 more worksheets, each containing the same 10 charts, linked to different data series. There weren't any issues copying these initally, but towards the last 8, 9 or 10 worksheets, the values on the final data point of each column chart would not update. I've tried closing the file in the hope it would refresh the data, but that didn't help. I'm not sure where to look next! Any suggestions or help would be appreciated! Thanks, Sean
  • 3. can i do multiple plots on 3d chart?
    I have various data sets that I want to plot on a single 3D chart to compare peak responses. Is this possible in excel?
  • 4. How to Chart XXY axis with different X axises
    Hello all, I have been searching around the forum to see if I can find an answer to create a XXY chart. I found one answer but it was not working for my case. Please help. X(1) will be in top, X(2) bottom. Plot Y1 and Y2. Thanks much! X axis(1) X axis(2) Y(1) Y(2) Jan-06 1/1/06 3 0 Feb-06 1/1/06 5 0 Mar-06 3/5/06 0 0 Apr-06 3/6/06 1 0

Dynamic Scaling

Postby Q29keQ » Wed, 13 Jul 2005 04:55:03 GMT

Is is possible to programmatically scale a chart?  Basically I want to force 
the chart's extents to be related to the extremities of my data.



Re: Dynamic Scaling

Postby Jon Peltier » Wed, 13 Jul 2005 06:58:16 GMT

Cody -

Here's how to use VBA to link your axis scale parameters to a set of 
worksheet cells:


- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions

Similar Threads:

1.Dynamic Scaling for Charts

We have some "canned" templates that include charts.   In some cases, when 
real data is entered, the scaling for the charts isn't what I would consider 
optimum.   For example:

All of the data is between 0.9 and 1.1, but the scale of the chart is 0 to 
1.2.   Any suggestions.  

Thanks in advance,
Barb Reinhardt

2.Dynamic Zoom and scaling Charts

A while back I had copied a sample dynamic chart that both 
zoomed and scaled and dynamically selected data to 
display. Since then I had to reimage my PC and I lost that 
sample chart.
Does anyone know where I find find the sample chart or any 
other ones that function the same way.


3.Dynamic Chart Scaling Error

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have finally figured out how to dynamically scale a chart that links to a table that can change by have the trailing cells empty. <br><br>The Table has two rows and 16 columns C6:R6 are dates and C7:R7 are numbers. When any of the cells at the end of the table are blank such as Q6 and R6 being blank I want the chart to only plot 14 data points. I should add C6:R7 are all formulas that reference another place in the work book. <br><br>That I did is define names Where the name "NBCL" is =OFFSET(Sheet1!$C$7,0,0,1,COUNT(Sheet1!$C$7:$R$7)) <br>
and "DATUP" is =OFFSET(Sheet1!$C$6,0,0,1,COUNT(Sheet1!$C$6:$R$6)) <br><br>I then write the Series equations as: <br>
=SERIES(,'Scaling experiment.xlsx'!DATUP,'Scaling experiment.xlsx'!NBCL,1)  <br><br>It works great except if all the data is removed from the table and then put back the Chart will not plot and I get the message "Your formula contains an invalid external reference to a worksheet". When I save the workbook, close it, and reopen it the chart now plots correctly again. <br><br>Why series equation never changes, so why does it do this?

4.Dynamically Scale Gantt Chart Time Scale

Excel 2007 (or 2010 Beta, if that's the only way to do it)

I've developed a Gantt Chart using a stacked bar chart.  It works great.  

Is there any way to have the horizontal axis (or vertical axis, I get 
confused with the terms in a stacked bar chart) expand in and out based on 
the MIN and MAX of the dates in the plotted range?

5.The scale on vertical axis equals to scale on vertical axis of ano


I have a chart that displays 'before product implementation' scenario and 
another one next to it that dispalys 'after product implementation'. The user 
will have two countries to choose from so I have to leave the scale on auto 
rather than fix it because the the countries have very different size 

What I would like to do is to make the vertical scale of graph 1 equal to 
the vertical scale of graph 2 so that I can show the impact of the product 
more clearly. Is there a way to do this which doesn't involved fixing the 

Many thanks in advance.



6. copy a scaled area in Excel into word with the same scale

7. Using "if" function to translate 100 scale into 4.0 scale

8. proper scaling in chart (with time-scale X-axis)

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 57 guest