Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problems with assigning range of cells to display chart
Hi, I'm working on a big Excel workbook and i'm having problems representing my data in a chart and this is where the problem is: I have a _scrollable_menu_ in my sheet that allows me to pick the month. Once the month is picked its data will be displayed. There's a Value X (Wholesale) that will be displayed after the selection of the month. I want to represent the wholesale from different months in my chart. I cannot assume that the wholesale is constant and copy the data somewhere else and create a chart. I want daily updates of the wholesale throughout the month. So how do i do that? I would appreciate any help..Thank you -- Richard Flame ------------------------------------------------------------------------ Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944 View this thread: http://www.excelforum.com/showthread...hreadid=557331 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problems with assigning range of cells to display chart
Perhaps you could adapt this example to your situation:
http://pubs.logicalexpressions.com/P...cle.asp?ID=246 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Richard Flame" wrote in message news:Richard.Flame.2a7y7c_1151677202.4351@excelfor um-nospam.com... Hi, I'm working on a big Excel workbook and i'm having problems representing my data in a chart and this is where the problem is: I have a _scrollable_menu_ in my sheet that allows me to pick the month. Once the month is picked its data will be displayed. There's a Value X (Wholesale) that will be displayed after the selection of the month. I want to represent the wholesale from different months in my chart. I cannot assume that the wholesale is constant and copy the data somewhere else and create a chart. I want daily updates of the wholesale throughout the month. So how do i do that? I would appreciate any help..Thank you -- Richard Flame ------------------------------------------------------------------------ Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944 View this thread: http://www.excelforum.com/showthread...hreadid=557331 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problems with assigning range of cells to display chart
Thank you it will help -- Richard Flame ------------------------------------------------------------------------ Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944 View this thread: http://www.excelforum.com/showthread...hreadid=557331 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Problems with assigning range of cells to display chart
Thank you it will help -- Richard Flame ------------------------------------------------------------------------ Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944 View this thread: http://www.excelforum.com/showthread...hreadid=557331 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to make Excel Chart not to display empty cells? | Charts and Charting in Excel | |||
Change scales from reference cells value for a chart in a separate sheet | Charts and Charting in Excel | |||
UDF is updateing cells on another sheet with count from current sheet. | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions |