Chart Series with Different Scales

Hi all,
If you have a chart and want to relate to different series, that have
different scales ie Number of Sales, and Revenue, per Day. Can you have
different axis scales so that 'number of sales ' is not scaled down to near
invisiblity.
I'm Working arround it by having two charts, but there should be a way to
have the two series on the same bar-chart.
AdrianSorry, secondary y-axis is currently not supported. Using two charts - as
you are already doing - is the best approach at this point.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"AdrianJMartin" <AdrianJMartin@.discussions.microsoft.com> wrote in message
news:2B313783-46EF-4942-80CE-AC193555E1D4@.microsoft.com...
> Hi all,
> If you have a chart and want to relate to different series, that have
> different scales ie Number of Sales, and Revenue, per Day. Can you have
> different axis scales so that 'number of sales ' is not scaled down to
> near
> invisiblity.
> I'm Working arround it by having two charts, but there should be a way to
> have the two series on the same bar-chart.
>
> Adrian|||I want to write an expression on major grid line how do i write
"Robert Bruckner [MSFT]" wrote:
> Sorry, secondary y-axis is currently not supported. Using two charts - as
> you are already doing - is the best approach at this point.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "AdrianJMartin" <AdrianJMartin@.discussions.microsoft.com> wrote in message
> news:2B313783-46EF-4942-80CE-AC193555E1D4@.microsoft.com...
> > Hi all,
> > If you have a chart and want to relate to different series, that have
> > different scales ie Number of Sales, and Revenue, per Day. Can you have
> > different axis scales so that 'number of sales ' is not scaled down to
> > near
> > invisiblity.
> >
> > I'm Working arround it by having two charts, but there should be a way to
> > have the two series on the same bar-chart.
> >
> >
> > Adrian
>
>|||I was able to develop a way to simulate a second y axis. In my case the data
source was a cube. I had two types of series, one with large, whole numbers,
and one with percentages, which caused the percentages to be at the zero
point when displayed with the other type of series. My solution was to write
a calculated member that found the maximum value of the whole number series
for all rows, and to round that value up to the next highest number.
Therefore, if the series returned 8,235 as the maximum value in any row, the
result of my calculated member would be 9,000. The 9,000 value of the
calculated member was returned for every row. In the graph I used the value
property of the percentage series to multiply the actual value by my
calculated member value. I used the label property to obtain the actual
percentage value. Thus, 80% became .8 * 9000 for plotting purposes, but the
data point label said 80%. The result was a successful combination of the
two very different types of series. The only thing that I could not do
without a true second y axis was having the tick marks and labels of a second
axis along the right side of the graph.
--
Brian C. Berg
MCSE+I, MCDBA
Berg Information Technology, Inc.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" wrote:
> Sorry, secondary y-axis is currently not supported. Using two charts - as
> you are already doing - is the best approach at this point.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "AdrianJMartin" <AdrianJMartin@.discussions.microsoft.com> wrote in message
> news:2B313783-46EF-4942-80CE-AC193555E1D4@.microsoft.com...
> > Hi all,
> > If you have a chart and want to relate to different series, that have
> > different scales ie Number of Sales, and Revenue, per Day. Can you have
> > different axis scales so that 'number of sales ' is not scaled down to
> > near
> > invisiblity.
> >
> > I'm Working arround it by having two charts, but there should be a way to
> > have the two series on the same bar-chart.
> >
> >
> > Adrian
>
>