Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 26
Default 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: __________________//_______.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 493
Default 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: __________________//_______.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Globally deleting part of the information in a cell JanetP Excel Worksheet Functions 4 November 19th 08 03:32 PM
Deleting part of the infomation in a cell Office Lapis Excel Discussion (Misc queries) 4 August 2nd 07 08:14 PM
Deleting time part of a Date, subtracting dates Shirley Munro Excel Discussion (Misc queries) 3 June 21st 06 11:58 AM
Deleting part of a cell PaolaAndrea Excel Discussion (Misc queries) 1 February 17th 06 06:51 AM
Omitting Part of the Y-Axis Dave McGuire Charts and Charting in Excel 2 July 25th 05 10:39 AM


All times are GMT +1. The time now is 09:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"