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. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|