Blank Charts and Paste Special


P

Puppet_Sock

Blank charts seem to be ignoring the settings in the paste-special
dialog.

Using Excel 2007.

I want to create several x-y scatter plots from different data sets.
There is some non-trivial formatting of the axis and legend and so on
that I want to maintain and not have to do over each time.

So, I made the graph once on one set of data. Then I made a copy. Then
on the copy I deleted all the data series. There are a bunch of
data series on each chart, so I didn't want to copy a chart with the
data on it. Then I made a copy of the now blank chart.

Then I did select-copy on the data for the next graph, selected the
graph, and did paste-special. On the dialog that opened I selected
Rows, Series Names in First Column, and Categories (X Values) in First
Row. And clicked Ok.

The graph comes out as columns, not rows. And it does not pay
attention to the Categories setting either.

Any help? I'd be happy with an alternative to accomplish what I
want (avoiding redoing the formatting on my chart for each one)
or a way to get it to take the data in rows, and use the first row
as X values and the first column as names.
Socks
 
Ad

Advertisements

P

Puppet_Sock

Blank charts seem to be ignoring the settings in the paste-special
dialog.
[snips]

So I figured this out.

My data headings are numeric. For example, I have a data
array that is radius across the top, and time down the side,
and the data is temperature. So I want to plot radial temperature
profiles for each time, and time profiles for each radius.
This is in addition to a surface plot of all the data.

But when the name of a series is a cell with a number in it,
the paste-special process will not recognize it as a name,
even when I specifiy name in first column and x values
in first row. And it is very annoying to have to go back and
manually make each curve the way it is supposed to be.

So, I figured out a trick. I copy the row and column heading
values to a saver location. Then I fill them with text before I
create the graph that uses them as headings. Then I copy
the numerical values back where they belong. This is way
fewer operations than manually changing 30 series on each
of twelve graphs.
Socks
 
G

GS

Puppet_Sock brought next idea :
Blank charts seem to be ignoring the settings in the paste-special
dialog.
[snips]

So I figured this out.

My data headings are numeric. For example, I have a data
array that is radius across the top, and time down the side,
and the data is temperature. So I want to plot radial temperature
profiles for each time, and time profiles for each radius.
This is in addition to a surface plot of all the data.

But when the name of a series is a cell with a number in it,
the paste-special process will not recognize it as a name,
even when I specifiy name in first column and x values
in first row. And it is very annoying to have to go back and
manually make each curve the way it is supposed to be.

So, I figured out a trick. I copy the row and column heading
values to a saver location. Then I fill them with text before I
create the graph that uses them as headings. Then I copy
the numerical values back where they belong. This is way
fewer operations than manually changing 30 series on each
of twelve graphs.
Socks

wouldn't it be easier to preface the numeric value with an apostrophe
so Excel recognizes it as text? (The apostrophe won't display in the
cell)
 
P

Puppet_Sock

Puppet_Sock brought next idea :




Blank charts seem to be ignoring the settings in the paste-special
dialog. [snips]

So I figured this out.
My data headings are numeric. For example, I have a data
array that is radius across the top, and time down the side,
and the data is temperature. So I want to plot radial temperature
profiles for each time, and time profiles for each radius.
This is in addition to a surface plot of all the data.
But when the name of a series is a cell with a number in it,
the paste-special process will not recognize it as a name,
even when I specifiy name in first column and x values
in first row. And it is very annoying to have to go back and
manually make each curve the way it is supposed to be.
So, I figured out a trick. I copy the row and column heading
values to a saver location. Then I fill them with text before I
create the graph that uses them as headings. Then I copy
the numerical values back where they belong. This is way
fewer operations than manually changing 30 series on each
of twelve graphs.
Socks

wouldn't it be easier to preface the numeric value with an apostrophe
so Excel recognizes it as text? (The apostrophe won't display in the
cell)

Well, but I need to use those values as numeric values when
I plot columns instead of rows. I just need them to be non-numeric
long enough to get the charts to plot the right way, then put them
back. Putting an apostrophe in front of every one of them would
probably be at least as much as copy a row, fill with x's, then
copy back when the cart is right.

But I do appreciate the suggestion. Thanks very much.
Socks
 
G

GS

Puppet_Sock expressed precisely :
Puppet_Sock brought next idea :




Blank charts seem to be ignoring the settings in the paste-special
dialog.
[snips]
So I figured this out.
My data headings are numeric. For example, I have a data
array that is radius across the top, and time down the side,
and the data is temperature. So I want to plot radial temperature
profiles for each time, and time profiles for each radius.
This is in addition to a surface plot of all the data.
But when the name of a series is a cell with a number in it,
the paste-special process will not recognize it as a name,
even when I specifiy name in first column and x values
in first row. And it is very annoying to have to go back and
manually make each curve the way it is supposed to be.
So, I figured out a trick. I copy the row and column heading
values to a saver location. Then I fill them with text before I
create the graph that uses them as headings. Then I copy
the numerical values back where they belong. This is way
fewer operations than manually changing 30 series on each
of twelve graphs.
Socks

wouldn't it be easier to preface the numeric value with an apostrophe
so Excel recognizes it as text? (The apostrophe won't display in the
cell)

Well, but I need to use those values as numeric values when
I plot columns instead of rows. I just need them to be non-numeric
long enough to get the charts to plot the right way, then put them
back. Putting an apostrophe in front of every one of them would
probably be at least as much as copy a row, fill with x's, then
copy back when the cart is right.

But I do appreciate the suggestion. Thanks very much.
Socks

Excel will ignore the apostrophe when referencing the contents. I'd
give it a try to see how that works...
 
Ad

Advertisements

Z

Zaidy036

Puppet_Sock brought next idea :




Blank charts seem to be ignoring the settings in the paste-special
dialog.
[snips]
So I figured this out.
My data headings are numeric. For example, I have a data
array that is radius across the top, and time down the side,
and the data is temperature. So I want to plot radial temperature
profiles for each time, and time profiles for each radius.
This is in addition to a surface plot of all the data.
But when the name of a series is a cell with a number in it,
the paste-special process will not recognize it as a name,
even when I specifiy name in first column and x values
in first row. And it is very annoying to have to go back and
manually make each curve the way it is supposed to be.
So, I figured out a trick. I copy the row and column heading
values to a saver location. Then I fill them with text before I
create the graph that uses them as headings. Then I copy
the numerical values back where they belong. This is way
fewer operations than manually changing 30 series on each
of twelve graphs.
Socks

wouldn't it be easier to preface the numeric value with an apostrophe
so Excel recognizes it as text? (The apostrophe won't display in the
cell)

Well, but I need to use those values as numeric values when
I plot columns instead of rows. I just need them to be non-numeric
long enough to get the charts to plot the right way, then put them
back. Putting an apostrophe in front of every one of them would
probably be at least as much as copy a row, fill with x's, then
copy back when the cart is right.

But I do appreciate the suggestion. Thanks very much.
Socks

free ASAP Utilities has this function
See:http://www.asap-utilities.com/
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top