ExcelBanter - Values on Axis

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Values on Axis (https://www.excelbanter.com/charts-charting-excel/177184-values-axis.html)

I have a line chart with three different values. monthly, quarterly, and
12months. they range from 15.0 to 55.00. the quarterly and the 12 month are
calculating off of the monthly using basic formulas. however, in my chart it
is not charting the quarterly and the 12 month with the correct values. for
instance it is showing 17.5 for quarterly to graphed at like 37. why is is
doing this and how do I fix it. Likewise the annual number is three times the
monthly amount. HELP

Hi,

Check the chart sub-type, sounds like you may be using Stacked Line.

Cheers
Andy

Mflynn wrote:
I have a line chart with three different values. monthly, quarterly, and
12months. they range from 15.0 to 55.00. the quarterly and the 12 month are
calculating off of the monthly using basic formulas. however, in my chart it
is not charting the quarterly and the 12 month with the correct values. for
instance it is showing 17.5 for quarterly to graphed at like 37. why is is
doing this and how do I fix it. Likewise the annual number is three times the
monthly amount. HELP

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info