View Full Version : Excel help (again) making charts look the same


Jess22
16-06-2008, 15:13
Hello,

I've accidently made a chart that I like. It's a 3D column chart, with 2 sets of data across the Y axis (2007, 2008) value scale going up the Z axis and 4 subjects going along the X axis. I added the data table in and it it joined onto the actual chart so the labels were from the table, not seperate floating. It looks good, and neat and shows the data well. Now everytime I try to repeat it, the data table apperas seperate and at a straight angle (the chart is at an angle, and it looks pants. How did I do it the first time?

Thanks in advance :)

Tricky
16-06-2008, 15:26
Have you tried copying your original, then selecting the new chart and going to
Edit-
> PasteSpecial
> Formats

??

Jess22
16-06-2008, 15:32
Thanks Tricky, I've tried this but it just asks me what I want the chart pasting as, and doesn't come up with format options.

Tricky
16-06-2008, 19:11
Your inbox is full.

Jess22
16-06-2008, 20:03
Sorry, emptied now