Dynamically Scale X Axis on Column Chart Based on Number of Catego
in [Charts]
|
Prev: Change All Data Labels in Excel 2007 Stacked Bar Chart
Next: Displaying zero values as gap in a chart
From: Andrew Lavinsky on 31 Jan 2010 07:56 Excel 2007: I have a column chart, with Milestone names appearing at the X axis, and Finish Variance displaying on the Y Axis. The chart displays the last four variance snapshots for each milestone. The Milestone axis is defined by a dynamic range. The question is how I can get the chart to adjust x-axis scale based on the number of milestones? When I delete half of the milestones, I am left with the same scale, with the remaining milestones along the left of the chart, and then a big empty space on the right of the chart. My preference is that the remaining milestones would get spread out through the entire set width of the chart. Thanks in advance.
From: Jon Peltier on 31 Jan 2010 22:56
> The Milestone axis is defined by a dynamic range. The axis is only indirectly defined by a range, dynamic or otherwise. How did you set up your dynamic ranges? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Andrew Lavinsky wrote: > Excel 2007: > > I have a column chart, with Milestone names appearing at the X axis, and > Finish Variance displaying on the Y Axis. The chart displays the last four > variance snapshots for each milestone. > > The Milestone axis is defined by a dynamic range. > > The question is how I can get the chart to adjust x-axis scale based on the > number of milestones? When I delete half of the milestones, I am left with > the same scale, with the remaining milestones along the left of the chart, > and then a big empty space on the right of the chart. My preference is that > the remaining milestones would get spread out through the entire set width of > the chart. > > Thanks in advance. |