ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Deleting part of X-axis range (https://www.excelbanter.com/charts-charting-excel/234321-deleting-part-x-axis-range.html)

tcek

Deleting part of X-axis range
 
I have a chart with x data that has many observations from 0 to 8 hours and a
single unit at 48 hours. I want to make the 0 to 8 data more visible. I
would prefer to have an axis that goes from 0 to 8 and then from 36 to 48.
How do I split/delete the 9 to 35 hour portion of the graph? Basically the x
axis would look somthing like: __________________//_______.

ALEX

Deleting part of X-axis range
 
Hi tcek, you have some ambition here, I have learnt a way to do so but it's a
little bit complicated, you may go here for some inspiration.. the author
shows how to do it for y-axis but similar applies for x-axis. Good luck!

http://peltiertech.com/Excel/Charts/BrokenYAxis.html
http://www.processtrends.com/pg_charts_custom_axis.htm

"tcek" wrote:

I have a chart with x data that has many observations from 0 to 8 hours and a
single unit at 48 hours. I want to make the 0 to 8 data more visible. I
would prefer to have an axis that goes from 0 to 8 and then from 36 to 48.
How do I split/delete the 9 to 35 hour portion of the graph? Basically the x
axis would look somthing like: __________________//_______.



All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com