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

Small Multiples Chart (problem dragging data into chart - please help)

G

greykitten

Member
Hello,

I was practicing creating a multiples chart using the directions from a Chandoo post. The directions instruct the user to create an area chart and then to add the same data twice using paste special in order to create data points. I am on Excel 2010 and I tried quite a few times copying the data and then pressing control V exactly as the directions state. The paste special option does not appear anytime when I try this.


Here is the file that I'm trying to create a small multiples chart with:

https://hotfile.com/dl/217695015/ab3dfc0/Small_Multiples_Chart.xlsx.html


Here is a link to the Chandoo post with the directions if this helps at all..

http://chandoo.org/wp/2011/11/16/small-multiples-charts-in-excel/


Please help!

greykitten
 
Paste special is found either by right-clicking, paste special

OR

On Home ribbon, click the dropdown on the Paste button, then select Paste Special

OR

Keyboard shortcut is: Alt+E, S
 
You must log in or register to reply here.
Back
Top