Date updates from worksheet to chart & changes date to a date series! Help!!

Hi,

I have a 2 sheet workbook, one sheet has my data -

Date	        Kg's
1/5/2003	91.0
2/8/2003	89.1
5/31/2003	90.1
8/21/2003	89.5
1/18/2004	89.9
2/2/2004	88.0
3/6/2004	88.1
4/17/2004	89.2
9/13/2004	88.5
10/4/2004	86.4
11/8/2004	87.3
12/21/2004	88.0

The second sheet has my chart.  When the date is carried over to the
chart, the dates are changed to a series of dates, starting 01/05/2003,
02/05/2003 etc...  The cells are formated to UK date on both the data
and the chart.  Any suggestions?  

Thanks

Jamie

0
1/20/2005 10:07:41 PM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
551 Views

Similar Articles

[PageSpeed] 26

JayJg,

One option would be to reference the cells containing your dates with 
formulas that change those dates to text.  Although Excel will now read the 
dates as text, they will look like dates on your chart.  For example, the 
formulas to reference the first three data points might look like this:  

=TEXT(A1,"m/d/yyyy")
=TEXT(A2,"m/d/yyyy")
=TEXT(A3,"m/d/yyyy")

Now, just reference the X-axis of your chart to the new date range.

----
Regards,
John Mansfield
http://www.pdbook.com


"Jayjg" wrote:

> Hi,
> 
> I have a 2 sheet workbook, one sheet has my data -
> 
> Date	        Kg's
> 1/5/2003	91.0
> 2/8/2003	89.1
> 5/31/2003	90.1
> 8/21/2003	89.5
> 1/18/2004	89.9
> 2/2/2004	88.0
> 3/6/2004	88.1
> 4/17/2004	89.2
> 9/13/2004	88.5
> 10/4/2004	86.4
> 11/8/2004	87.3
> 12/21/2004	88.0
> 
> The second sheet has my chart.  When the date is carried over to the
> chart, the dates are changed to a series of dates, starting 01/05/2003,
> 02/05/2003 etc...  The cells are formated to UK date on both the data
> and the chart.  Any suggestions?  
> 
> Thanks
> 
> Jamie
> 
> 
0
1/21/2005 2:01:01 AM
Probably it would be easier to change from a time scale axis to a category axis. 
Select the chart, choose Chart Options from the Chart menu, click on the Axes tab, 
and change the category axis option from Automatic to Category.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

John Mansfield wrote:

> JayJg,
> 
> One option would be to reference the cells containing your dates with 
> formulas that change those dates to text.  Although Excel will now read the 
> dates as text, they will look like dates on your chart.  For example, the 
> formulas to reference the first three data points might look like this:  
> 
> =TEXT(A1,"m/d/yyyy")
> =TEXT(A2,"m/d/yyyy")
> =TEXT(A3,"m/d/yyyy")
> 
> Now, just reference the X-axis of your chart to the new date range.
> 
> ----
> Regards,
> John Mansfield
> http://www.pdbook.com
> 
> 
> "Jayjg" wrote:
> 
> 
>>Hi,
>>
>>I have a 2 sheet workbook, one sheet has my data -
>>
>>Date	        Kg's
>>1/5/2003	91.0
>>2/8/2003	89.1
>>5/31/2003	90.1
>>8/21/2003	89.5
>>1/18/2004	89.9
>>2/2/2004	88.0
>>3/6/2004	88.1
>>4/17/2004	89.2
>>9/13/2004	88.5
>>10/4/2004	86.4
>>11/8/2004	87.3
>>12/21/2004	88.0
>>
>>The second sheet has my chart.  When the date is carried over to the
>>chart, the dates are changed to a series of dates, starting 01/05/2003,
>>02/05/2003 etc...  The cells are formated to UK date on both the data
>>and the chart.  Any suggestions?  
>>
>>Thanks
>>
>>Jamie
>>
>>

0
1/22/2005 3:00:29 PM
Reply:

Similar Artilces:

Before Update on record select
I am getting no where fast. I have a main form and sub form and what i need is a message to appear when user moves on to the next record using the record selector on the bottom of the form. I have tried the beforeupdate on the form but no results. Can form design prevent a message prompt? One problem is that if no changes to the current record have been changed, the Before Update event will not fire. If you do make a change, the code as is should work. I have gotten into the habbit of not using the standard record navigators, but write my own so I can easily deal with this. -- Dave Ha...

New Disk storage
Hi, I'm planning on adding a new SAN to our Exchange system (Active/Passive 2 node cluster) and this has been connected to the Exchange cluster nodes and is accessible as shared disk storage. But that isn't the question I've got, basically the mail stores are currently located on a Powervault (Drive S:) and I need to present a plan for moving this data (14 databases) onto the SAN storage, I can see two options Option1) Use the ESM to migrate databases to new drive letter 1. Use exmerge to export all email to PST files (and ensure backup) 2. use the ESM utility to change the...

Address book updating...
Hello all, I have noticed since we moved to Exchange 2003 that it takes a long time (several hours) before I see newly created accounts in the address book. Is there somewhere I can adjust the update time? TIA, Gary Check the update interval in the RUS (Recipient Update Service). Teo "GaryH" wrote: > Hello all, > I have noticed since we moved to Exchange 2003 that it takes a long time > (several hours) before I see newly created accounts in the address book. > Is there somewhere I can adjust the update time? > TIA, > Gary > > > Thank you...I will ...

Exchange update problem
I have tried to upgrade exch2k3 sp1 to sp2, but the update fails with "the file pcproxy.dll is in use, and setup cannot identify the app or srvc. setup cannot continue" Any clues/ideas/suggestions? Please. -- ----------------------------------------------------------------------------------------------------------------------- This message has been checked for all known viruses. The information contained in this e-mail and any attachments is confidential and may be the subject of legal, professional or other privilege. It is intended for the named addressee only and may not ...

how do I automatically update a text box in a chart?
Hi, You can link the textbox to a cell. When you update the cell the textbox should reflect this. Select the textbox border and then in the formula bar enter the complete cell reference, for example, =Sheet1!A1 Cheers Andy Kath wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info ...

Using part of a cell in a chart title
I have a chart which should get a title. However, this should be partly be used from a cell e.g. "counted with 5%" 5% should be taken from the cell and used in the title. Is this possible? Hi, Yes it's possible but all of the chart title needs to be in the cell. So you may need to use a helper cell and concatenate text and value. http://www.andypope.info/tips/tip001.htm Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Nicole" <Nicole@discussions.microsoft.com> wrote in message news:5CB7A971-AA7F-4C34-BB42-7DC283AA2958@micro...

worksheet tabs 01-06-10
Hi In the 2003 excel-- Is there a way to have the worksheet tabs automatically go in alphabetical order-- or do you have to do in manually? -- Thank-you! Ruth Ruth, Use this code: Sub ArrangeSheetsInOrder() Dim iCount As Integer Application.ScreenUpdating = False iCount = Sheets.Count For i = 1 To iCount - 1 For j = i + 1 To iCount If Sheets(j).Name < Sheets(i).Name Then Sheets(j).Move Before:=Sheets(i) End If Next j Next i End Sub "Ruth" wrote: > Hi > > In the 2003 excel-- Is there a way to have the worksheet tabs automatically ...

Sort ascending, make changes, restore previous order
I've got an AutoFilter in a spreadsheet. I want to sort ascending, mak some changes to some cells, then restore the previous order. Can thi be done easily or will this require some programming?? Thanks in advane! Matt -- BVHi ----------------------------------------------------------------------- BVHis's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=859 View this thread: http://www.excelforum.com/showthread.php?threadid=47508 I'd use a helper column. Put =row() and drag down. Convert it to values (edit|copy, edit|paste special|values) Do all y...

How do you change the background color of a picture?
I have a image that I have copy and pasted, however I want to fill behind the image. I know how to fill and all that, my problem is that it recognizes the entire image as a picture, I was wondering if there is a way to change the background while the image lays on top? sureisdifferent wrote: > I have a image that I have copy and pasted, however I want to fill > behind the image. I know how to fill and all that, my problem is that > it recognizes the entire image as a picture, I was wondering if there > is a way to change the background while the image lays on top? =============...

Need help with Auto Filter
I have a spreedsheet that is filtered in multiple columns. I am running a "Subtotal" function to count certian rows when I filter the column. My question is this. Is there a way to save or freeze the data that the subtotal function counts in a different cell. In other words I want subtotal to count everything in a particular column but I want to be able to save that number somewhere so that when I filter again with another variable I am able to still view the first subtotal to compare the two. I hope this makes sense and thanks in advance for any assistance you can provi...

How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?
Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change the default Style for e-mails from 'Normal' to 'Normal (Web)'. The problem is that new e-mails and replies in HTML format use the 'Normal' Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of this is that when sending an e-mail, I have to press return twice to create a gap, but when the recipient views this, their software shows it as four gaps (the extra carriage return I typed + their correctly viewed HTML carriage return after each line). E.g. I type this: ...

Chart template?
I am working with a chart, created from a pivot table. The chart has the various [drop down] fields available for selecting different values for the chart to show. I have formatted the chart with specific settings, fonts, colors, etc., but everytime I use one of the dropdowns, the formatting goes back to the default. I have looked for a place to save as a template, or defaults without luck. Thanks for any help you can provide! Alan ...

Radar chart in Access 2007 report
Can you add a Radar chart to an access 2207 report? ...

How to change font size on formula bar in Excell 2007
I don't find Tools>Options>General (as suggested in other post answers) in Excel 2007. On the Office button there is an Excel Options but it doesn't provide a method of changing font size on the office but. My font is so small I can barely see it. Office button>ExcelOptions>Popular tab>in the "When creating new workbooks" section, choose font and font size -- Kind regards, Niek Otten Microsoft MVP - Excel "jimwillie" <jimwillie@discussions.microsoft.com> wrote in message news:588AAC05-0F52-404E-AA01-128E70E02D0B@microso...

Change File Locations to Private Drive (not Folder)
Hi, I know that I can use "File Locations" in "Options" so that whenever I use the "Open..." command in Word, it will open to a specific folder. I'm wondering if there is a way that this can be applied not to a folder but to a specific drive on a network. Our company has a main public drive and has also assigned each of the Staff their own private drive. Is there a way to access the "main page" (for lack of a better term) of my private drive each time I use "Open..." in Word? Right now it goes to "My Computer" or ...

help with simple maths in excel
I want to do a simple arithmatic excercise in excel for my grand daughter. It is stuff like 2+2 =4 Smart me has hit a problem at the first hurdle... I need to put 2 in one cell the + in another cell and then 2 in another = in another and then she puts the answer in the next one. So the above would have 4 cells completed and she would put the answer in the 5th one. When I use the + or = sign in a cell of its own it (excel) thinks I am doing an equation, is there a way around this? I will work on the answer like if she gets it correct or wrong how I will do that...a sound or som...

Help with income/expenses
Running 2003 in home page I setup income and expenses I prefer to see one whole month. Money some how shows it as 1/22/2006 through 2/20/2006 any way to fix this? Thanks Jeff ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- ...

HELP! Need to export hourly sales data on POS (NOT RMS)
How can I export hourly sales data across a date range? For instance, I want to show hourly sales for the month of October so I can graph it and post it in our break room. If I can't export hourly data, can I export daily sales? The built-in reports don't address this data format. This is a multi-part message in MIME format. ------=_NextPart_000_008E_01C826DC.CBC512D0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response Content-Transfer-Encoding: 7bit Mark, This should work for you. Keep in mind it takes up to 5-10 minutes to load...

Excel Problem
I have a 23.8 meg excel 2000 spreadsheet set for manual calculation saved to my local hard drive. Every time I try to open it, it takes forver and sometimes never opens but I do not get any error messages, let me just tell you that I am running a P4, 1 GB memory, Office 2K with SP3, and nothing else running when I try to open it. As I said it is set for manual calculation, and it is cleared to not auto calculate when opening or closing. Any idea's as to why this is happening? -- Todd I don't know why you're having this problem but I would like to point something out for w...

Need Query Help
I have two tables, Table A & Table B, in my database that have the same fields (Name, SSN, etc). Most of the records in both tables are identical, but each table has some unique records. I would like to run a query that will select the unique records in Table A by comparing SSNs, and then do the same for Table B. I am a database novice, and have tried all the wizards and expression builders with no luck. Any help at all would be appreciated. Thank you!!! Scott Casa Grande, AZ Hi Scott, The "Find Unmatched Query Wizard" is what you need. If you only want to check for SSNs ...

dates #5
Is there a formula to ad a numeric value to the name of a month. I am running a query in excel (pulling from an external source) and would like to sort as teh table refreshes by month and year. I have code to to do the refresh and the sort, but it sorts in alphabetical order. I was thinking a formula could place a numeric value to the month (1 = Jan, 2 = Feb, etc) and I can sort based on that. Is there an easy formula to do this. Thanks in advance Your easy formula could be: =MATCH(A1,{"Jan","Feb","Mar","Apr","May","Jun"...

Can anyone help ?
I have created a holiday planner for staff with in are company and i need a formula that gives us only 10% of the total number of staff are off on holiday. would be greatful if anyone could help. Hello - If you have a total somewhere (I would suggest inserting a column on your spreadsheet titled Total and then entering a "1" if the person is going to be out, then total the column of "1"s by entering "=SUM(x:y)" where x=first cell in the range, and y=last cell in the range), in a different cell, enter "=.1*z" where z equals the total of people out...

how do i change colour of scroll bar in worksheet
I find it very difficult to see the scroll bar in my excel workshhet as they are white, can they be changed to a colour and if so how ? Are the scrollbars white in other applications? In win98, I could change some display settings, but I couldn't change the scrollbar colors. But if the scrollbars aren't white in other applications, then this can't be the solution. Jayne wrote: > > I find it very difficult to see the scroll bar in my excel workshhet as they > are white, can they be changed to a colour and if so how ? -- Dave Peterson In word they are, but not on a...

Embedded Chart Versus Chart
I've created a class module to capture a Shift+Click on a pivot chart, which then opens the data associated with that point. It works great on pivot charts on their own sheet, but when I use the same code on an embedded chart, it fails (error code -2147417848). Everything seems to work fine, it derives the same row and column values as needed, but the ShowDetail property is unavailable in the embedded charts. Anyone have any insight? james Igoe || james.igoe@gmail.com || http://code.comparative-advantage.com I eventually solved my problem, simply using "On Error Resume Next&...

Linking information form one worksheet to another
Hi, i have a big problem i want to create a link between some columns in two seperate worksheets, so that when i type a name on the master sheet it would give me the required information.Dont know if i explained this right, lets say on the master sheet i have columns : Name,Sex and Height on columns A,D and BH respectively i want that if i type a person's name in worksheet 2 it should give me the results on columns A,C,F in that worksheet. Please help i need it asap for my director One way .. Assuming your "master" sheet is named: Master, with data in row1 down In Shee...