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

On Apr 14, 2:00*pm, Puppet_Sock <puppet_s...@hotmail.com> wrote:
> 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

Puppet_Sock brought next idea :
> On Apr 14, 2:00*pm, Puppet_Sock <puppet_s...@hotmail.com> wrote:
>> 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)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

On May 4, 4:07*pm, GS <g...@somewhere.net> wrote:
> Puppet_Sock brought next idea :
>
>
>
>
>
> > On Apr 14, 2:00*pm, Puppet_Sock <puppet_s...@hotmail.com> wrote:
> >> 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

Puppet_Sock expressed precisely :
> On May 4, 4:07*pm, GS <g...@somewhere.net> wrote:
>> Puppet_Sock brought next idea :
>>
>>
>>
>>
>>
>>> On Apr 14, 2:00*pm, Puppet_Sock <puppet_s...@hotmail.com> wrote:
>>>> 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...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

In article <3b45da2d-487c-46a7-98e7-(E-Mail Removed)>,
Puppet_Sock at (E-Mail Removed) says...
>
> On May 4, 4:07*pm, GS <g...@somewhere.net> wrote:
> > Puppet_Sock brought next idea :
> >
> >
> >
> >
> >
> > > On Apr 14, 2:00*pm, Puppet_Sock <puppet_s...@hotmail.com> wrote:
> > >> 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/


--
Zaidy