| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Is there a way to split the y-axis values in a chart?
Hi,
Then you will need two breaks, no? Although to be honest remove a strip of 100 from the top and bottom halves of the chart will not make the data in between much clearer if that is the point of breaking the axis. Cheers Andy otyokwa wrote: What if the numbers are in the middle of a scatter chart - Have data 0 to 100 and then 900 to 1000? I would like to cut out the middle numbers - 200 to 800... "Andy Pope" wrote: Hi, Here are some examples of split axis. http://peltiertech.com/Excel/Charts/BrokenYAxis.html http://tushar-mehta.com/excel/newsgr...ial/index.html http://www.andypope.info/charts/brokencolumn.htm Cheers Andy otyokwa wrote: I am trying to make a scatter graph with some high values and some low values -say 0 to 100 and 900 to 1000. Is there a way to have the y-axis display 0 to 100 then a line with values 900 to 1000 above the line? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reversing the axis on a chart | Charts and Charting in Excel | |||
| tick mark labels | Charts and Charting in Excel | |||
| how to put x axis values in the chart instead of x axis labels | Charts and Charting in Excel | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Threaded Mode
