Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can you create a break in the chart scale
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 |
#2
|
|||
|
|||
Hi,
Axis breaks are not a built in feature but they can be created. Here is an example, including links to alternatives. http://www.andypope.info/charts/brokencolumn.htm Cheers Andy duncanw wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |