A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

data range referrences



 
 
Thread Tools Display Modes
  #21  
Old June 11th, 2009, 08:25 PM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default data range referrences

No, the problem wasn't the lack of 2007. I tried from my VM, which has 2007,
and the web site couldn't find 2007. When I went ahead anyway, the template
was not found.

Then I tried using IE (I was using FireFox) with or without 2007, same
result.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Jon Peltier" wrote in message
...
"The template you are trying to access was not found."

I think the problem is that the MS site "helpfully" checks whether I have
2007 installed on my machine (I do, but on a VM, not on the main machine).
If not, I get an option to download manually, and when I click on that
link, it can't believe I haven't upgraded to the newest, glitteriest
spreadsheet program in history, so it can't bring itself to find the file.

Why they can't just put up a simple freaking link, I don't know. They've
pushed the compatibility pack onto everyone anyway, so why should they
care?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______



"Archimedes' Lever" wrote in message
...


Hunt up on the recent submissions "WallyWallWhackr" or "Blood Pressure
Tracker for entire year".

It is on the first page of the "recently submitted" community
templates. on the templates main page at microsoft.com

http://office.microsoft.com/search/r... 100632981033

or, the main templates page and select "recently submitted" in the left
column:

http://office.microsoft.com/en-us/te...595491033.aspx



On Thu, 11 Jun 2009 09:38:26 -0400, "Jon Peltier"
wrote:

"The template you are trying to access was not found."

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Archimedes' Lever" wrote in message
...
On Sat, 6 Jun 2009 15:43:55 -0400, "Jon Peltier"
wrote:

If this were my project (sorry, I don't have time to make it mine) I
think
I
would have used an Excel List or Table as the data entry region, kept
dates
in one column, and not fed a pivot table with this. I'd build a set of
worksheet controls that would allow the user to select a time range to
plot,
on a chart with a date scale on the X axis.

I showed an example that worked like this he

Dynamic Charting By Dates -
http://pubs.logicalexpressions.com/P...cle.asp?ID=246



I made this:

http://office.microsoft.com/en-us/my...058731033.aspx

There is no Feb 29 handling currently as MS does not accept macro
enabled template submissions.

There are no pivot charts or tables. Feb 29 messes up the charts, even
with the #N/A () in place in the date fields, which are one axis.

So I omit your IF statement test string, and was using a button to
hide
or unhide that row in two locations. That actually works, and also
likely with the area chart under discussion elsewhere. That is a good
way to code it, if it works with all the charts. Is MS going to patch
SP2 to solve its problems I have been reading about?

Anyway, take a gander at my workbook, if you get a moment. I think
the
macro buttons could be eliminated, and the test and change be automated
in a single macro with no need for user interaction (simply run the
test
and hide or unhide the rows).

Thanks again, Jon, for all the help you have given me. My work is
close to completion, and much better than the previous version thanks
to
your help, and the exercises it put me through.

'Grade' my spreadsheet if you would. I like feedback. I should make
it so the user can select that chart plot line colors on the first page
as well. That would be cool, as then the user could make easy
universal
color changes without the recursive exercise of activating all the
pertinent sheets and setting the colors and saving. Having a choice
dialog would make it point and click.

Anyone that monitors and tracks their blood pressure should give it a
glance as well.





  #22  
Old June 11th, 2009, 11:57 PM posted to microsoft.public.excel.charting
Archimedes' Lever
external usenet poster
 
Posts: 47
Default data range referrences

On Thu, 11 Jun 2009 14:43:51 -0400, "Jon Peltier"
wrote:

I think the problem is that the MS site "helpfully" checks whether I have
2007 installed on my machine (I do, but on a VM, not on the main machine).



That is correct. When I am at work, my templates do not show up as we
are 2k3 at work.
  #23  
Old June 12th, 2009, 12:02 AM posted to microsoft.public.excel.charting
Archimedes' Lever
external usenet poster
 
Posts: 47
Default data range referrences


No?

Darn.


http://office.microsoft.com/search/r... 101436151033

The string has "assetid" in it. I wonder what that could be...?

Can you not get a friend to grab it for you and send it to you?

At least they finally got the thumbnail screenshots working.

Dang! You cannot see that either!


On Thu, 11 Jun 2009 14:43:51 -0400, "Jon Peltier"
wrote:

"The template you are trying to access was not found."

I think the problem is that the MS site "helpfully" checks whether I have
2007 installed on my machine (I do, but on a VM, not on the main machine).
If not, I get an option to download manually, and when I click on that link,
it can't believe I haven't upgraded to the newest, glitteriest spreadsheet
program in history, so it can't bring itself to find the file.

Why they can't just put up a simple freaking link, I don't know. They've
pushed the compatibility pack onto everyone anyway, so why should they care?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______



"Archimedes' Lever" wrote in message
.. .


Hunt up on the recent submissions "WallyWallWhackr" or "Blood Pressure
Tracker for entire year".

It is on the first page of the "recently submitted" community
templates. on the templates main page at microsoft.com

http://office.microsoft.com/search/r... 100632981033

or, the main templates page and select "recently submitted" in the left
column:

http://office.microsoft.com/en-us/te...595491033.aspx



On Thu, 11 Jun 2009 09:38:26 -0400, "Jon Peltier"
wrote:

"The template you are trying to access was not found."

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Archimedes' Lever" wrote in message
...
On Sat, 6 Jun 2009 15:43:55 -0400, "Jon Peltier"
wrote:

If this were my project (sorry, I don't have time to make it mine) I
think
I
would have used an Excel List or Table as the data entry region, kept
dates
in one column, and not fed a pivot table with this. I'd build a set of
worksheet controls that would allow the user to select a time range to
plot,
on a chart with a date scale on the X axis.

I showed an example that worked like this he

Dynamic Charting By Dates -
http://pubs.logicalexpressions.com/P...cle.asp?ID=246



I made this:

http://office.microsoft.com/en-us/my...058731033.aspx

There is no Feb 29 handling currently as MS does not accept macro
enabled template submissions.

There are no pivot charts or tables. Feb 29 messes up the charts, even
with the #N/A () in place in the date fields, which are one axis.

So I omit your IF statement test string, and was using a button to hide
or unhide that row in two locations. That actually works, and also
likely with the area chart under discussion elsewhere. That is a good
way to code it, if it works with all the charts. Is MS going to patch
SP2 to solve its problems I have been reading about?

Anyway, take a gander at my workbook, if you get a moment. I think the
macro buttons could be eliminated, and the test and change be automated
in a single macro with no need for user interaction (simply run the test
and hide or unhide the rows).

Thanks again, Jon, for all the help you have given me. My work is
close to completion, and much better than the previous version thanks to
your help, and the exercises it put me through.

'Grade' my spreadsheet if you would. I like feedback. I should make
it so the user can select that chart plot line colors on the first page
as well. That would be cool, as then the user could make easy universal
color changes without the recursive exercise of activating all the
pertinent sheets and setting the colors and saving. Having a choice
dialog would make it point and click.

Anyone that monitors and tracks their blood pressure should give it a
glance as well.


  #24  
Old June 12th, 2009, 12:03 AM posted to microsoft.public.excel.charting
Archimedes' Lever
external usenet poster
 
Posts: 47
Default data range referrences

On Thu, 11 Jun 2009 15:25:43 -0400, "Jon Peltier"
wrote:

No, the problem wasn't the lack of 2007. I tried from my VM, which has 2007,
and the web site couldn't find 2007. When I went ahead anyway, the template
was not found.

Then I tried using IE (I was using FireFox) with or without 2007, same
result.


It is there, andI definitely get a different list at work than I do
here.Are you sure a virtualized installation gets "seen" correctly at the
MS site?


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Jon Peltier" wrote in message
...
"The template you are trying to access was not found."

I think the problem is that the MS site "helpfully" checks whether I have
2007 installed on my machine (I do, but on a VM, not on the main machine).
If not, I get an option to download manually, and when I click on that
link, it can't believe I haven't upgraded to the newest, glitteriest
spreadsheet program in history, so it can't bring itself to find the file.

Why they can't just put up a simple freaking link, I don't know. They've
pushed the compatibility pack onto everyone anyway, so why should they
care?

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______



"Archimedes' Lever" wrote in message
...


Hunt up on the recent submissions "WallyWallWhackr" or "Blood Pressure
Tracker for entire year".

It is on the first page of the "recently submitted" community
templates. on the templates main page at microsoft.com

http://office.microsoft.com/search/r... 100632981033

or, the main templates page and select "recently submitted" in the left
column:

http://office.microsoft.com/en-us/te...595491033.aspx



On Thu, 11 Jun 2009 09:38:26 -0400, "Jon Peltier"
wrote:

"The template you are trying to access was not found."

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______


"Archimedes' Lever" wrote in message
m...
On Sat, 6 Jun 2009 15:43:55 -0400, "Jon Peltier"
wrote:

If this were my project (sorry, I don't have time to make it mine) I
think
I
would have used an Excel List or Table as the data entry region, kept
dates
in one column, and not fed a pivot table with this. I'd build a set of
worksheet controls that would allow the user to select a time range to
plot,
on a chart with a date scale on the X axis.

I showed an example that worked like this he

Dynamic Charting By Dates -
http://pubs.logicalexpressions.com/P...cle.asp?ID=246



I made this:

http://office.microsoft.com/en-us/my...058731033.aspx

There is no Feb 29 handling currently as MS does not accept macro
enabled template submissions.

There are no pivot charts or tables. Feb 29 messes up the charts, even
with the #N/A () in place in the date fields, which are one axis.

So I omit your IF statement test string, and was using a button to
hide
or unhide that row in two locations. That actually works, and also
likely with the area chart under discussion elsewhere. That is a good
way to code it, if it works with all the charts. Is MS going to patch
SP2 to solve its problems I have been reading about?

Anyway, take a gander at my workbook, if you get a moment. I think
the
macro buttons could be eliminated, and the test and change be automated
in a single macro with no need for user interaction (simply run the
test
and hide or unhide the rows).

Thanks again, Jon, for all the help you have given me. My work is
close to completion, and much better than the previous version thanks
to
your help, and the exercises it put me through.

'Grade' my spreadsheet if you would. I like feedback. I should make
it so the user can select that chart plot line colors on the first page
as well. That would be cool, as then the user could make easy
universal
color changes without the recursive exercise of activating all the
pertinent sheets and setting the colors and saving. Having a choice
dialog would make it point and click.

Anyone that monitors and tracks their blood pressure should give it a
glance as well.




  #25  
Old June 16th, 2009, 03:38 AM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default data range referrences


"Archimedes' Lever" wrote in message
...
On Thu, 11 Jun 2009 15:25:43 -0400, "Jon Peltier"
wrote:

No, the problem wasn't the lack of 2007. I tried from my VM, which has
2007,
and the web site couldn't find 2007. When I went ahead anyway, the
template
was not found.

Then I tried using IE (I was using FireFox) with or without 2007, same
result.


It is there, andI definitely get a different list at work than I do
here.Are you sure a virtualized installation gets "seen" correctly at the
MS site?


Neither my VMs nor my regular machine worked. I don't know why they can't
just post a link, like the rest of the world does.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


  #26  
Old June 16th, 2009, 05:30 AM posted to microsoft.public.excel.charting
Archimedes' Lever
external usenet poster
 
Posts: 47
Default data range referrences

On Mon, 15 Jun 2009 22:38:33 -0400, "Jon Peltier"
wrote:


"Archimedes' Lever" wrote in message
.. .
On Thu, 11 Jun 2009 15:25:43 -0400, "Jon Peltier"
wrote:

No, the problem wasn't the lack of 2007. I tried from my VM, which has
2007,
and the web site couldn't find 2007. When I went ahead anyway, the
template
was not found.

Then I tried using IE (I was using FireFox) with or without 2007, same
result.


It is there, andI definitely get a different list at work than I do
here.Are you sure a virtualized installation gets "seen" correctly at the
MS site?


Neither my VMs nor my regular machine worked. I don't know why they can't
just post a link, like the rest of the world does.

- Jon


They segregate o2k7 and keep you from DLing "non-compliant" templates
for o2k3.


I can post it to a hosting site.

http://www.mediafire.com/?zmzqznvomxa
  #27  
Old June 22nd, 2009, 02:57 AM posted to microsoft.public.excel.charting
Jon Peltier
external usenet poster
 
Posts: 5,018
Default data range referrences


"Archimedes' Lever" wrote in message
...
On Mon, 15 Jun 2009 22:38:33 -0400, "Jon Peltier"
wrote:


"Archimedes' Lever" wrote in message
. ..
On Thu, 11 Jun 2009 15:25:43 -0400, "Jon Peltier"
wrote:

No, the problem wasn't the lack of 2007. I tried from my VM, which has
2007,
and the web site couldn't find 2007. When I went ahead anyway, the
template
was not found.

Then I tried using IE (I was using FireFox) with or without 2007, same
result.


It is there, andI definitely get a different list at work than I do
here.Are you sure a virtualized installation gets "seen" correctly at
the
MS site?


Neither my VMs nor my regular machine worked. I don't know why they can't
just post a link, like the rest of the world does.

- Jon


They segregate o2k7 and keep you from DLing "non-compliant" templates
for o2k3.


So they should let me click on a link for "Download Excel 2007 Workbook",
and if it doesn't work in 2003 it's my problem. Why do they feel the need to
babysit all of their users?

I can post it to a hosting site.

http://www.mediafire.com/?zmzqznvomxa


Thanks.

The problem is that you're using a multiple-level category axis. #N/A is
treated as a bit of text, and the axis extends to include the #N/A in the
date column.

If you're only protecting the charts to prevent the user accidentally
breaking something, don't bother with a password. I was not able to change
the category axis data range to verify that a single level category axis
scale, using #N/A for the 29th, would not show Feb 29 on non leap years.

Well, actually I could break the password. Most passwords in Office are not
very secure. And yes, if the X values includes only one column, not two,
then the axis behaves as I told you it would.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.