Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Values on Axis
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Values on Axis
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |