#### The dates on the category (X) axis label do not match data?

```I have a chart that pulls dollars in sales and charts it by date.  The dates
are off in the charts by a few days.  What am I doing wrong?
```
 0
TKGerdie (7)
7/18/2005 4:18:06 PM
excel.charting 18370 articles. 0 followers.

1 Replies
421 Views

Similar Articles

[PageSpeed] 52

```check first in <Chart><Source data><series>
and check that your X and y data has the appropriate staring points.
also if the dates on the chart are tilted,  it may just look like they are
not on the correct spot.  Double click on the axis and set the alignment to
90 degrees.

"TKGerdie" wrote:

> I have a chart that pulls dollars in sales and charts it by date.  The dates
> are off in the charts by a few days.  What am I doing wrong?
```
 0
BJ (832)
7/18/2005 6:05:22 PM

Similar Artilces:

filter by date and action
I have a table with three columns: Name Date Action Fred Today this Fred Today this Fred Today that Wilma Today this I want to sort by name and by date, but only if 'this' was done more than once on the same day, and not if 'that' was done on the same day,They have to perform this more than once, and they cannot have performed that on the same day. If not in excel, mssql maybe? Thanks, Harry On Aug 18, 1:53=A0pm, Harry <hamac...@gmail.com> wrote: > I have a table with three co...

Calculate Years/Months Between Dates and then Average
We are using the formula =DATEDIF(A1,NOW(),"y") & "." & DATEDIF(A1,NOW(),"ym") to calculate the years and months from an employee hire date. Is there an easy way to average the years and months for a group of employees with the results of that formula? You could use: =AVERAGE(A1:A10*1) Array-entered, meaning press ctrl-shift-enter. But you could also just change your current formula to: =1*(DATEDIF(A1,NOW(),"y") & "." & DATEDIF(A1,NOW(),"ym")) Then just use: =AVERAGE(A1:A10) which is *not* array-entered. ...

crm data migration.
Hi I want to import the contact information from LOTUS NOTES databease into CRM database?Tell me the best way? Thank you... Hi, I have a client who has a lotus installation. From what i see, there is a ability to export lotus data into excel sheet. Convert this excel sheet into a tab/comma delimited file and you can import into ms crm. "mergen" <mergen@discussions.microsoft.com> wrote in message news:5111F577-CDB3-445B-B073-D6BA4573C378@microsoft.com... > Hi > > I want to import the contact information from LOTUS NOTES databease into CRM > database?Tell me ...

Our accounting department needs/wants to have all RMS SO reporting by business date opposed to transaction date. Usually these are the same unless you have sales and batches that close after midnight. For our store I would like to set 3 a.m. as the business day closing time. So when I run any type of reports I would like to get the information for a business date (range) starting at 3 a.m. till 3 a.m. the next day. I guess I could accomplish this by subtracting 3 hours from all the transaction (date and) times but I would have to do this for every single report which would be a lot of ...

Restrict Data Entry in Combo Box
Is there any way to prevent a user from typing into a Combo Box and onl selecting items by selecting them from the drop down menu? I'm tryin to reduce data entry errors from the user. Thanks a lot, Ripa -- Message posted from http://www.ExcelForum.com Hi If your list is "fixed" could you not just create a list in a worksheet and use Data > Validation > Allow > List (Select your list range). It produces a drop-down list similar to your combo-box and the user can't change any entries. >-----Original Message----- >Is there any way to prevent a user from ...

Post Dated Checks
I had to prepare some post dated checks and we did not have fiscal periods set up yet to match the dates of the checks. Currently the check batches are waiting to be posted. What is the best way to handle post dated checks? If I create new fiscal years to match these dates, I will end up having 4 Open years. Is this the only way to do it? You can manage post dated checks in Microsoft Dynamics GP with the Payment Document Management module available on the Feature Pack 1 DVD image. For more info, take a look at MVP Mohammad Daoud's post on the subject at: https://communit...

External SQL data
Sorry for the lack of knowledge. I have some spreadsheets which pull data from sql database thru an ODBC connection. Since upgrading to 2007, when I "Edit query" on some of these spreadsheets, it starts to connect then I get a warning saying that it is changing to database context XXX. The database it is changing to is the one I want but the warning I get only lets me click on OK, but the query window does not open. I have seen some documents that this say this is just a warning but when it is reported, it stops the script from completing. I don't have a clue ...

truncating data within a cell for an entire column
Hi, I have a numeric value in a cell that is followed by a space and then three alphanumeric characters e.g., -24 dBm. How can I delete the alphanumeric chracters and preserve the nummeric charaters so that I can apply the average function to the entire column? Thanks, vlapi vlapi wrote: > Hi, > I have a numeric value in a cell that is followed by a space and then three > alphanumeric characters e.g., -24 dBm. How can I delete the alphanumeric > chracters and preserve the nummeric charaters so that I can apply the average > function to the entire column? > Thanks, >...

Color categories
Thanks in advance for taking the time to read this... We have offices in different locations and want to assign a color for each office. We can then add items to a shared calendar with the color assigned for that office so we all know what office is doing what on any given day. With that said: 1) Is there a way to assign colors to people as a default and then have that color show automatically as they post items to this shared calendar? If so is there a way to only assign that color as they post on the shared calendar as I would NOT want this when they add items to their own...

data validation and autocomplete -- again...
hi, i've looked at the discussions about this topic, and i can't help but feel someone must have created a better solution. does anyone know of a better solution? the problem is simple: 1. i have a chart of accounts list 2. i want to enter text that is likely to be in this list, and want autocomplete to save keystroke effort by scrolling to that place in the list, or at least autofilling, so i can then just hit enter. thanks for any help here, fred thanks max, this is very helpful. fred "Max" <demechanik@yahoo.com> wrote in message news:eQov1Fo6EHA.28...

Remove "Date: Yesterday" or "Date: Monday" from Outlook Inbox?
Outlook mail inbox now has headers that tell you what day the the email was sent. I find this visually annoying. Each emailalready has the time and day it was sent. I don't need the daily titles in the midst of the list of emails. How do I make them go away? I think you are talking about OL 2003 & the Arrange in Groups setting. Change it in View, Arrange by, uncheck Show in Groups. "silky" wrote: > Outlook mail inbox now has headers that tell you what day the the email was > sent. I find this visually annoying. Each emailalready has the time and day >...

strange date format problem
Hi, I downloaded some data on excel using Bloomberg. One column has dates and the other has numbers. Dates appear as 01/01/1980 format which I want in Jan-80 format. I have changed the format cell properties but it still appears as 01/01/1980. I have to goto individual cell and press F2 <enter> so see the effect. Dont know why? I cant even copy paste format after that .... TIA/amag I am not sure, but is your workbook set to Auto-Recalculate? Try pushing <F9> to do a manual re-calculation, see if that changes the formats. If it does, go to Tools (on the menu bar), Options, Ca...

data migration wizard problem
Hello there I try to import account into crm 3.0 by dmf and it doesnt seems to work. Here is insert I am using to populate cdf (under) as accountid i use (1,2,3 ... ) as owning user name (my domain\login) wizard runs and ..... writes that all records are not migrated from cdf... log doesnt show any errors .. please help tell me what is required because i have done all that is in mapping description. INSERT INTO cdf_mscrm..cdf_Account ( AccountID ,AccountNumber ,Name ,PrimaryContactName ,Telephone1 ,Telephone2 ,Address1_Telephone1 ,Fax ,Ad...

Create Categories
I have data in a table which I imported from a Survey Monkey excel file. I have begun to create a report (in design view) using the fields from this table. My problem is I don't know how to separate (or group) the fields by category based on the data I have in the table. Each question in the survey is one of the fields in the Access table. Unfortunately, there is no way to tell what fields belong to which category based on the data in the table. The survey had 37 questions which were grouped by category: Professionalism - 6 questions Quality of Work - 10 questions Contribut...

How to sort by name then date?
I would like to look through all the emails to a particular person. If I click on the "To" column I can see all the emails to a particular person (actually there is a problem with that which I will mention next) but they seem to be in random order. Is there a way to have them sorted by date? (i.e. by name first, then by date). Actually, sorting on the "To" column does not get all the emails sent to a given email address. Because Outlook uses the "display as" field. It will often give different "display as" names to the same email address. C...

data series and axis labels
I will try my best to ask this question in a way that makes sense- I have a line chart showing monthly sales. My X axis is labeled Jan - Dec and my data series is the sales by month. I have figures for Jan Feb Mar and Apr but since May - Dec are at \$0 my chart currently shows a straight line down from Apr to May. Is it possible to stop the line at April yet keep the axis showing Jan - Dec? Thanks! On Thu, 10 May 2007, in microsoft.public.excel.charting, cdwinlib <cdwinlib@discussions.microsoft.com> said: >I have a line chart showing monthly sales. My X axis is labeled Jan - ...

Append Data In Worksheet To Access Table
There is an Access table on the network. 15 users who do not have Access are connected to the network. Is there a way for each user to be able to enter one or more rows containing 3 or 4 columns to Excel on his machine and then press a button or something and append that data to the Access table on the network? Also would need to delete the data from the worksheet after the append. How would I prevent more than one user from appending data at the same time? Any suggestions on what the code would be? Thank you very much! Martin Hi Martin, Please lookin to "TransferSpreadsheet" ...

Concatenate including a date so that the date appears as a date
When I try to join the contents of several cells, one of which is a date and time obtained from =now(), the date and time part appears as a number. How can I make it appear as a date and time? I have tried changing the cell formats - probably there is a combination that works but I haven't found it. I also tried copying the original date cell to another cell and changing the latter cell's format and concatenating using that latter cell, but still no success. Use the TEXT function. For example, =TEXT(NOW(),"mmmm d, yyyy") would give January 6, 2010 "dd...

if statement with dates #2
I would like to have a statement like: IF(a1>0,1/1/2004) with 1/1/2004 beint a date. EXCEL is interpreting 1/1/2004 as an arithmetic statement and giving me the result of the arithemtic. I could put in the numeric offste for the date and write IF(a1>0,37987), formatting the cell as a date, but this seems awkward. What else can I do? TIA, Sanford ...

Two columns on X-axis
How can I get a 90 degrees text alignment on x-axis from two columns. It's only column B taht rotate. Column A is still horisontel. The serie in column C gives a graf. Select whatever it is you want rotated 90=B0 Press Ctrl + 1 On the Alignment tab, under Orientation, set it to 90=B0 Click OK ...