7928688.........conver this number using custom number format into 1000 mean i need custom number formating 7929 same goes with othe rnumber also.
Date: Mon, 5 Mar 2012 16:49:27 +0530 Subject: $$Excel-Macros$$ Help On Chart From: shrinivas...@gmail.com To: excel-macros@googlegroups.com Dear Experts I want a help for charts. I wants to make a 3 charts in one graph,but problem is that the ranges are different for eg ranges are as follows range -1 =: 13 to 15 range -2 =: 19 to 22 range -1 =: 28 to 32 If i make all the charts in one graph then the scale will taken as from (min 13 to max 32) which is very large scale suppose there is a reading in the range (12.8, 13.1, 12.5) due to large scale it doesnot show difference on graph Actually I want is that Can I adjust the Y scale Like (13 to 15 then 19 to 22 and then 28 to 32) as there is no reading in between DAta sheet and graph attached (chart1 sheet 1) Waiting for reply Thanks in advance Ragards Shrinivas -- Shrini -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com