• 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.

Charts

J

Joeman187

Member
Hi Chandoo People,

I was reading an article on panel charts on your website. It said if you wanted to create multiple charts press ctrl d. What I don't know how to do is to put the different data from the table in
each of the charts. Your help is most appreciative. Thank you, Joe from Michigan.
 
Hi Joe ,

Whenever an embedded chart ( a chart which is on a worksheet rather than in its own sheet ) is selected , the series data range(s) are highlighted. When you press CTRL D , a duplicate chart is immediately inserted on the worksheet , and the same data range(s) will be highlighted.

Excel highlights the axis range using one colour , the data range using a second colour , the title cell(s) using a third colour and so on. This highlight is a thin coloured line. When you move the mouse over the line , the cursor will change its style with 4 directional arrows in the 4 directions , and the thin line now becomes a thick line.

You can now drag the mouse to select a different range. The chart reflects this change immediately.

In the blog post , this technique has been separately explained in :

http://chandoo.org/wp/2009/05/05/edit-formulas-with-mouse/

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