| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
date at chart
I am using MS EXCEL 2003. I want to add date dynamicly (only MONTH)to a chart. How can i do this? -- external ------------------------------------------------------------------------ external's Profile: http://www.excelforum.com/member.php...o&userid=36592 View this thread: http://www.excelforum.com/showthread...hreadid=563748 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
date at chart
In article ,
says... I am using MS EXCEL 2003. I want to add date dynamicly (only MONTH)to a chart. How can i do this? Given the brevity of your question, about the best I can suggest is that you look at Dynamic Charts http://www.tushar-mehta.com/excel/ne...rts/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
date at chart
i looked those links.But i didnt solve my problem. Please help me thankss... -- external ------------------------------------------------------------------------ external's Profile: http://www.excelforum.com/member.php...o&userid=36592 View this thread: http://www.excelforum.com/showthread...hreadid=563748 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
date at chart
On Sun, 23 Jul 2006, in microsoft.public.excel.charting,
external said: i looked those links.But i didnt solve my problem. Please help me thankss... Nobody can help you if you don't describe your problem more fully. Is it that you want the month to display on your chart? Try creating a cell with the formula =TODAY() then format it with the custom format "mmmm", so that it shows "July". Now create a text box in your chart, and (this is the tricky bit) use the edit bar to make the box refer to the cell you made. It's no good just typing "=A1" into the text box itself, that will just show "=A1". Now your text box should show "July" on the chart, and next month it will show "August", and so on. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| How do I get the date correct in excel 2000 on a chart? | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| How do I chart date ranges with varying start and finish dates? | Charts and Charting in Excel | |||
| Bar Chart Date XAxis Thin Bars | Charts and Charting in Excel | |||
Hybrid Mode
