| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can i drop the year from dd/mm/yyyy for graph
Answered when you asked earlier in another thread.
-- David Biddulph "Chris26" wrote in message ... Hi I am using Excel 2007 Column A Column B 1 Jan 2000 75.55 2 Jan 2000 75.37 to 31 Dec 2009 74.98 I have data spanning a number of years. I would like to plot that data on same "line graph" to compare profiles of each year and values for any given day/month. Can I get excel to "Ignore" the Year and just use the day/month portion of the date. If not can anyone recommend a workaround. Horizontal scale to be 1st Jan to 31st Dec. Then the vertical scale to be based on Column B Many Thanks Chris |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort "mm-dd-yyyy" by year | Excel Discussion (Misc queries) | |||
| Excel function to convert month-day-year to mm/dd/yyyy | Excel Worksheet Functions | |||
| Converting Day, Date Month Year format to MM/DD/YYYY | Excel Worksheet Functions | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| Elimate year (either YY or YYYY) in data | Excel Discussion (Misc queries) | |||
![David Biddulph[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
