Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY Scatter chart - Axis Option
Hi, I have a user who has created an XY scatter chart, and within the
horizontal axis options dialog box chose a fixed 100.0 maximum. This mark is not showing on his chart. If we increase the value to 200.0, the 100 marker appears. any ideas as to why the 100 mark would not show even when the option indicates 100.0? Choosing "Auto" does not fix it. Since I'm not familiar with these types of charts, I'm not sure what information to provide. It seems that if the option was set to 100.0 maximum, the 100 marker should display on the chart. Thanks for any suggestions. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY Scatter chart - Axis Option
To add a little more information, per the user:
"The chart wants to show the data in the range between 0.01 and 100. Though you may go to 200, I just want to stop at 100 as I have other companying figures that have the same horizontal range. The same is true for the range of vertical axis. The key is to make sure the last number on the axes can show up, that is 100 on the horizontal axis and 10 on the vertical axis." suggestions? "Tammy" wrote: Hi, I have a user who has created an XY scatter chart, and within the horizontal axis options dialog box chose a fixed 100.0 maximum. This mark is not showing on his chart. If we increase the value to 200.0, the 100 marker appears. any ideas as to why the 100 mark would not show even when the option indicates 100.0? Choosing "Auto" does not fix it. Since I'm not familiar with these types of charts, I'm not sure what information to provide. It seems that if the option was set to 100.0 maximum, the 100 marker should display on the chart. Thanks for any suggestions. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY Scatter chart - Axis Option
Hi,
Try setting the Maximum to 100.1 and I assume the Number format is already set to something like #0.0 The values displayed are based on the Minimum Value + increments of the Major Unit. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Tammy" wrote in message ... To add a little more information, per the user: "The chart wants to show the data in the range between 0.01 and 100. Though you may go to 200, I just want to stop at 100 as I have other companying figures that have the same horizontal range. The same is true for the range of vertical axis. The key is to make sure the last number on the axes can show up, that is 100 on the horizontal axis and 10 on the vertical axis." suggestions? "Tammy" wrote: Hi, I have a user who has created an XY scatter chart, and within the horizontal axis options dialog box chose a fixed 100.0 maximum. This mark is not showing on his chart. If we increase the value to 200.0, the 100 marker appears. any ideas as to why the 100 mark would not show even when the option indicates 100.0? Choosing "Auto" does not fix it. Since I'm not familiar with these types of charts, I'm not sure what information to provide. It seems that if the option was set to 100.0 maximum, the 100 marker should display on the chart. Thanks for any suggestions. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
XY Scatter chart - Axis Option
Thank you very much, Andy! My user is very happy!
Tara! "Andy Pope" wrote: Hi, Try setting the Maximum to 100.1 and I assume the Number format is already set to something like #0.0 The values displayed are based on the Minimum Value + increments of the Major Unit. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Tammy" wrote in message ... To add a little more information, per the user: "The chart wants to show the data in the range between 0.01 and 100. Though you may go to 200, I just want to stop at 100 as I have other companying figures that have the same horizontal range. The same is true for the range of vertical axis. The key is to make sure the last number on the axes can show up, that is 100 on the horizontal axis and 10 on the vertical axis." suggestions? "Tammy" wrote: Hi, I have a user who has created an XY scatter chart, and within the horizontal axis options dialog box chose a fixed 100.0 maximum. This mark is not showing on his chart. If we increase the value to 200.0, the 100 marker appears. any ideas as to why the 100 mark would not show even when the option indicates 100.0? Choosing "Auto" does not fix it. Since I'm not familiar with these types of charts, I'm not sure what information to provide. It seems that if the option was set to 100.0 maximum, the 100 marker should display on the chart. Thanks for any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scatter chart x axis problem | Charts and Charting in Excel | |||
text label in x-axis (scatter chart) | Charts and Charting in Excel | |||
Scale on X & Y Axis of the scatter chart | Charts and Charting in Excel | |||
How do I add a second y-axis in an xy(Scatter) chart? | Charts and Charting in Excel | |||
Scatter Chart Axis as text C# | Charts and Charting in Excel |