• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how to split line chart in ms excel 2007 [SOLVED]

I

imran khan

New Member
i have a line chart containing 30 months (m1 ---- m30) like

m1 m2 m3 m4 ----------- m30

a 10 20 25 30 ........... 100

b 12 15

c 10 12


when i create chart is seem se to too long but what i need is that i want to split this chart after 13 month but see unto 30 months. like ( m1 m2 m3 m4 m4 m6 m13 n30) that i could see my chat value (b, c) bit visible and clear..
 
Hi Imran ,


What you can do is add a scroll bar so that you can always see 13 months of data , and you can scroll through all the 30 months. Check the following links :


1. http://www.techrepublic.com/blog/10things/10-steps-to-creating-a-scrolling-excel-chart/3454


2. http://www.spreadsheetshoppe.com/add-a-scroll-bar.html


3. http://www.officetooltips.com/excel/tips/creating_a_scrolling_chart.html


4. http://articles.excelyogi.com/scrolling-excel-charts-scrollbar-graphs/2009/03/13/


Narayan
 
You must log in or register to reply here.
Back
Top