Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart question - Walkenbachs book
Hi guys,
I recently bought Walkenbachs book on charting and got some great tips and hints on how to improve the presentation of my work. I have a question though which I couldn't figure out from the book. Does somebody have an example of an interactive chart, whereby you can choose the labels of x-axis of the chart ? For example, in the same chart, I want to allow the user to select monthly OR quarterly OR YTD sales information. The labels of the x-axis will change accordingly (as will the scale of the y-axis). In other words, the user "just" has to select the time frame. I see some resemblance with the chart "select series with checkboxes" of Chapter 7 of Walkenbachs book, but in my case I want to select the time frame (month, quarter, YTD) and not the data series as such. Lastly, I wasn't able to find an example of the chart whereby quarterly info is shown vertically and monthly info is shown horizontally ? (although Walkenbach shows an example in the chart gallery i.e. chart 077). Where can I find the workings of this chart in his book ? Thanks guys Steve P |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart question - Walkenbachs book
What about a pivot chart?
"Steve P" wrote in message ... Hi guys, I recently bought Walkenbachs book on charting and got some great tips and hints on how to improve the presentation of my work. I have a question though which I couldn't figure out from the book. Does somebody have an example of an interactive chart, whereby you can choose the labels of x-axis of the chart ? For example, in the same chart, I want to allow the user to select monthly OR quarterly OR YTD sales information. The labels of the x-axis will change accordingly (as will the scale of the y-axis). In other words, the user "just" has to select the time frame. I see some resemblance with the chart "select series with checkboxes" of Chapter 7 of Walkenbachs book, but in my case I want to select the time frame (month, quarter, YTD) and not the data series as such. Lastly, I wasn't able to find an example of the chart whereby quarterly info is shown vertically and monthly info is shown horizontally ? (although Walkenbach shows an example in the chart gallery i.e. chart 077). Where can I find the workings of this chart in his book ? Thanks guys Steve P |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart question - Walkenbachs book
mmm, haven't thought about that, would that do the trick
in the most efficient manner ? Would this give me the option to change time frames (month, quarter, YTD)in the same chart ? I was more thinking of doing something in VBA... Thanks for your comment anyway. Steve P -----Original Message----- What about a pivot chart? "Steve P" wrote in message ... Hi guys, I recently bought Walkenbachs book on charting and got some great tips and hints on how to improve the presentation of my work. I have a question though which I couldn't figure out from the book. Does somebody have an example of an interactive chart, whereby you can choose the labels of x-axis of the chart ? For example, in the same chart, I want to allow the user to select monthly OR quarterly OR YTD sales information. The labels of the x-axis will change accordingly (as will the scale of the y-axis). In other words, the user "just" has to select the time frame. I see some resemblance with the chart "select series with checkboxes" of Chapter 7 of Walkenbachs book, but in my case I want to select the time frame (month, quarter, YTD) and not the data series as such. Lastly, I wasn't able to find an example of the chart whereby quarterly info is shown vertically and monthly info is shown horizontally ? (although Walkenbach shows an example in the chart gallery i.e. chart 077). Where can I find the workings of this chart in his book ? Thanks guys Steve P . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart question - Walkenbachs book
It depends on the data. As I recall, Walkenbachs book (Excel 2000 power
programming with VBA) has an example that uses uses the calculated item field to provide the same kind result. I.e., Q1 = JAN + FEB + MAR, etc. This should work with a pivot chart, also. "Steve P" wrote in message ... mmm, haven't thought about that, would that do the trick in the most efficient manner ? Would this give me the option to change time frames (month, quarter, YTD)in the same chart ? I was more thinking of doing something in VBA... Thanks for your comment anyway. Steve P -----Original Message----- What about a pivot chart? "Steve P" wrote in message ... Hi guys, I recently bought Walkenbachs book on charting and got some great tips and hints on how to improve the presentation of my work. I have a question though which I couldn't figure out from the book. Does somebody have an example of an interactive chart, whereby you can choose the labels of x-axis of the chart ? For example, in the same chart, I want to allow the user to select monthly OR quarterly OR YTD sales information. The labels of the x-axis will change accordingly (as will the scale of the y-axis). In other words, the user "just" has to select the time frame. I see some resemblance with the chart "select series with checkboxes" of Chapter 7 of Walkenbachs book, but in my case I want to select the time frame (month, quarter, YTD) and not the data series as such. Lastly, I wasn't able to find an example of the chart whereby quarterly info is shown vertically and monthly info is shown horizontally ? (although Walkenbach shows an example in the chart gallery i.e. chart 077). Where can I find the workings of this chart in his book ? Thanks guys Steve P . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart question - Walkenbachs book
A pivot table can group a row variable - so if your raw data are dates, you
can group at week, month, I believe quarter, and year. -- Regards, Tom Ogilvy "Steve P" wrote in message ... mmm, haven't thought about that, would that do the trick in the most efficient manner ? Would this give me the option to change time frames (month, quarter, YTD)in the same chart ? I was more thinking of doing something in VBA... Thanks for your comment anyway. Steve P -----Original Message----- What about a pivot chart? "Steve P" wrote in message ... Hi guys, I recently bought Walkenbachs book on charting and got some great tips and hints on how to improve the presentation of my work. I have a question though which I couldn't figure out from the book. Does somebody have an example of an interactive chart, whereby you can choose the labels of x-axis of the chart ? For example, in the same chart, I want to allow the user to select monthly OR quarterly OR YTD sales information. The labels of the x-axis will change accordingly (as will the scale of the y-axis). In other words, the user "just" has to select the time frame. I see some resemblance with the chart "select series with checkboxes" of Chapter 7 of Walkenbachs book, but in my case I want to select the time frame (month, quarter, YTD) and not the data series as such. Lastly, I wasn't able to find an example of the chart whereby quarterly info is shown vertically and monthly info is shown horizontally ? (although Walkenbach shows an example in the chart gallery i.e. chart 077). Where can I find the workings of this chart in his book ? Thanks guys Steve P . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving worksheets to another book - 2nd book will not appear | Excel Discussion (Misc queries) | |||
copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
to disconnect a destination book from a source book | Excel Discussion (Misc queries) | |||
bank book or pass book | Excel Worksheet Functions | |||
Copy Excel Chart from one book to other without links... | Charts and Charting in Excel |