Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Scatter Chart Axis as text C#
Hi, I'm creating a scatter chart in C#, and I need its X axis values to be
dates or strings that represent dates... the data source where I get the data from is a DataTable with 2 columns... X,Y, which X are dates and Y floats, can Anyone help me display the dates in the X axis...? Pablo -- Message posted via http://www.officekb.com |
#2
|
|||
|
|||
A XY Scatter chart can have dates on the x-axis without any additional
work. Just make sure you have the dates set up as XL understands them (which I believe is how all MS Office apps understand them). The whole number part is the number of days since 1/1/1900 (or 1/1/1904 if using that date numbering system) and the fraction part represents the time of day (0.0 is midnight; 0.5 is midday; and 0 with an increment of the whole number part, i.e., 1.0 being the next midnight). -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi, I'm creating a scatter chart in C#, and I need its X axis values to be dates or strings that represent dates... the data source where I get the data from is a DataTable with 2 columns... X,Y, which X are dates and Y floats, can Anyone help me display the dates in the X axis...? Pablo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Second X axis at top of chart? | Charts and Charting in Excel | |||
Scatter chart x axis tick mark lables | Charts and Charting in Excel | |||
the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |