The reason why not to put it onto the first chart, the first chart has the
line going from point to point (which is from center of category to center
of category). The second chart is the line that goes from the left edge to
the right edge, which is using the Area Chart as the option for it, as it's
an area chart that allows for lines to go from edge to edge within the plot
area.
--
Thanks,
Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
"Peter T" <peter_t@discussions> wrote in message
news:%(E-Mail Removed)...
>I didn't quite take all that in, why the two charts, and is the two charts
> related to the update problem (I can't imagine why it should be).
>
> It seems the second chart is merely to place a line over the main chart.
> If(?) that's the intent why not place it on the main chart, various ways
> to
> do that.
>
> Regards,
> Peter T
>
> "Ronald R. Dodge, Jr." <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Excel 2002, SP3
>>
>> I am actually using 2 charts to make up the apparence of 1 chart.
>>
>> The first chart is the area chart so as I can get the goal line to go
> across
>> the entire plot area. (This is the chart that I'm having issues with)
>>
>> The second chart is a line chart, which as an object, is over the top of
> the
>> area chart.
>>
>> Both charts are setup as interpolated, so as lines are drawn from data
> point
>> to data point which other fields either being left as blank or having the
>> formula of "=NA()" are skipped on over as far as line drawing on the
> charts
>> is concerned.
>>
>> Data Source of the area chart is setup as "Charts!B37:P37" (If I put in
> the
>> "Q" in place of the "P", line wouldn't go all the way to the right side
>> of
>> the plot area)
>> Data Source of the line chart is setup as "Charts!B39:Q39" and
>> "Charts!B41:Q41"
>>
>> The workbook (among others) is set to "Manual Calculation", which even
> when
>> using Shift-F9 manually, or using one of the following 2 VBA codes, the
>> chart does not update as would be expected:
>>
>> Note, the m_chtProductionRateAreaChart is the ChartObject
>>
>> m_chtProductionRateAreaChart.Chart.Refresh
>>
>> Or
>>
>> m_wshOperatorCharts.Calculate 'The worksheet the chart and data are on.
>>
>> One more thing I have noticed. It seems after the VBA code is done with
> it
>> all, the Line Chart is selected, and I'm not sure if this is causing a
>> problem with the area chart or not.
>>
>> If you will, for rows 37 through 41, each row is it's own row, no 2 rows
> are
>> merged together, but every 2 columns between B and S are merged together
> so
>> as to be able to have the data on the worksheet centered between the grid
>> lines on the chart while allowing for both 1st shift and 3rd shift data
> for
>> those same days showing side by side below on the worksheet. Yes, this
>> means data points are shown a bit to the left side rather than centered
>> on
>> the line chart, but that will be dealt with later as that's just a
> cosmetic
>> issue, and I already have an idea how to resolve that issue This goal
> area
>> chart not adjusting properly is more of an issue cause it's gives off the
>> wrong perception by far.
>>
>> The only way I so far have been able to find to get the chart to update
>> properly is to manually adjust the Y axis setting to either include or
>> exclude the tick label. However, by doing that, it would also mean that
>> I
>> would have to reset the Left and Width properties of the PlotArea on the
>> chart. I'm already having to set these settings within VBA anyhow on my
>> chart objects so as they print out properly. The code is adjusting the
>> MaximumScale and MajorUnit properties on the Value Axis properly as
>> expected, just not refreshing the graph itself, which would be the
>> values.
>>
>> --
>> Thanks,
>>
>> Ronald R. Dodge, Jr.
>> Production Statistician
>> Master MOUS 2000
>>
>>
>
>
Similar Threads
