Values on Axis

M

Mflynn

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
 
A

Andy Pope

Hi,

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

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Periodicity in a Chart 1
change axis values 3
presenting quarterly time series data 2
Automate chart X-axis/data 1
Sum months into quarters? 3
Quarterly data with years on the x-axis 3
IF Function 6
formula too long 1

Top