Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Is possible to change the scale of the chart to reflect a large range of data ie creat a break in the scale? I have a data set that consists of variables ranging from 25 to 0.1, there are roughly three variables that are in between 20 - 25 and the remainder are (25) are in the range of 0.1 to 1. As such, when I graph this data in a regular bar chart I can only see the three variables that are between 20 - 25 as the scale does not allow me to the lower valued variables. In regards to this problem I would like to break the scale so it would ready, 0.2, 0.2,0.3 ....1, 5, 10, 15, 20, 25. If you can help with this problem it would be much appreciated. -- duncanw ------------------------------------------------------------------------ duncanw's Profile: http://www.excelforum.com/member.php...o&userid=26866 View this thread: http://www.excelforum.com/showthread...hreadid=401064 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I create a stacked bar chart in excel | Charts and Charting in Excel | |||
Chart scale & paper size | New Users to Excel | |||
How do I create a "backwards" chart | Charts and Charting in Excel | |||
Create a custom chart, two stacked bars/month w/ two axes? | Charts and Charting in Excel | |||
Timeline Chart? | Charts and Charting in Excel |