Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I plot values to match log scale on chart? Ron Hudson
Some of the lower values, the start and stop of the bars, are ok. Some
higher values which appear in higher decades do not match the chart values. What is wrong and how should I fix it? Ron Hudson |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I plot values to match log scale on chart? Ron Hudson
Hi,
Possible answer - on a log scale the increments are not equal distance apart. Therefore a value of 75 is not halfway between 50 and 100. This is the correct. Cheers, Shane Devenshire "Ron Hudson" <Ron wrote in message ... Some of the lower values, the start and stop of the bars, are ok. Some higher values which appear in higher decades do not match the chart values. What is wrong and how should I fix it? Ron Hudson |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I plot values to match log scale on chart? Ron Hudson
Are you perhaps using a 3-D effect? If so, you can get a misleading
impression of the height of a column. -- David Biddulph "Ron Hudson" <Ron wrote in message ... Some of the lower values, the start and stop of the bars, are ok. Some higher values which appear in higher decades do not match the chart values. What is wrong and how should I fix it? Ron Hudson |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I plot values to match log scale on chart? Ron Hudson
Hi Ron,
In some situations you can present your data better by converting it to log values first and then plot it on a natural scale as opposed to the normal way of plotting natural values on a log scale. Just some food for thought Martin "Ron Hudson" <Ron wrote in message ... Some of the lower values, the start and stop of the bars, are ok. Some higher values which appear in higher decades do not match the chart values. What is wrong and how should I fix it? Ron Hudson |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I plot values to match log scale on chart? Ron Hudson
In stacked bars, each bar reaches to the sum of it and all previous bars. If
the two items in the stack are 2 and 3, the first bar goes to 2, the second goes to 3 more than that, or 5. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ron Hudson" <Ron wrote in message ... Some of the lower values, the start and stop of the bars, are ok. Some higher values which appear in higher decades do not match the chart values. What is wrong and how should I fix it? Ron Hudson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't change the scale of values on a y-axis on a line chart | Charts and Charting in Excel | |||
how do I setup a pie chart that does not plot zero values ? | Charts and Charting in Excel | |||
Huge differences in chart values screws my bar chart scale up. | Charts and Charting in Excel | |||
How do I plot chart with negative value using Logarithmic Scale ? | Charts and Charting in Excel | |||
Chart Axis Scale Auto Values | Charts and Charting in Excel |