Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Labels
Since my chart is a daily chart over a few years, I don't have data labels
displayed on my chart. However, the user can run their curser over a point on the chart and it will display the date and value at that point. My problem is the date is sometimes displayed in it's numeric equivalent (i.e "38546") and other times it actually displays the date (7/13/05). How can I stop the chart from displaying the numeric equivalent? I can't figure out why sometimes the date shows and somtimes the numeric equivalent shows. Thanks! |
#2
|
|||
|
|||
Do you have just one data set or several being plotted. What is the format
of the input X data? "TJB" wrote: Since my chart is a daily chart over a few years, I don't have data labels displayed on my chart. However, the user can run their curser over a point on the chart and it will display the date and value at that point. My problem is the date is sometimes displayed in it's numeric equivalent (i.e "38546") and other times it actually displays the date (7/13/05). How can I stop the chart from displaying the numeric equivalent? I can't figure out why sometimes the date shows and somtimes the numeric equivalent shows. Thanks! |
#3
|
|||
|
|||
One set of data being plotted. A $ value for a particular day and the chart
covers a five year period. The X data is the date format "*3/14/2001" and the Y data in the $ format. "bj" wrote: Do you have just one data set or several being plotted. What is the format of the input X data? "TJB" wrote: Since my chart is a daily chart over a few years, I don't have data labels displayed on my chart. However, the user can run their curser over a point on the chart and it will display the date and value at that point. My problem is the date is sometimes displayed in it's numeric equivalent (i.e "38546") and other times it actually displays the date (7/13/05). How can I stop the chart from displaying the numeric equivalent? I can't figure out why sometimes the date shows and somtimes the numeric equivalent shows. Thanks! |
#4
|
|||
|
|||
is this an XY plot or a line plot?
if ther raw data for the X values are formated as dates, it should show up as dates for your point and look try selecting the input values and firast format as general. check to see if some show as dates and some show as numbers reformat the X data series in the worksheet as date and see what you get. "TJB" wrote: One set of data being plotted. A $ value for a particular day and the chart covers a five year period. The X data is the date format "*3/14/2001" and the Y data in the $ format. "bj" wrote: Do you have just one data set or several being plotted. What is the format of the input X data? "TJB" wrote: Since my chart is a daily chart over a few years, I don't have data labels displayed on my chart. However, the user can run their curser over a point on the chart and it will display the date and value at that point. My problem is the date is sometimes displayed in it's numeric equivalent (i.e "38546") and other times it actually displays the date (7/13/05). How can I stop the chart from displaying the numeric equivalent? I can't figure out why sometimes the date shows and somtimes the numeric equivalent shows. Thanks! |
#5
|
|||
|
|||
Double click the data labels, on the Number tab apply the desired
format, then make sure the Linked to Source box is not checked. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ TJB wrote: One set of data being plotted. A $ value for a particular day and the chart covers a five year period. The X data is the date format "*3/14/2001" and the Y data in the $ format. "bj" wrote: Do you have just one data set or several being plotted. What is the format of the input X data? "TJB" wrote: Since my chart is a daily chart over a few years, I don't have data labels displayed on my chart. However, the user can run their curser over a point on the chart and it will display the date and value at that point. My problem is the date is sometimes displayed in it's numeric equivalent (i.e "38546") and other times it actually displays the date (7/13/05). How can I stop the chart from displaying the numeric equivalent? I can't figure out why sometimes the date shows and somtimes the numeric equivalent shows. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column format when merging Excel data to Word labels | Excel Discussion (Misc queries) | |||
"Bring to Front" Data Labels? | Charts and Charting in Excel | |||
Is there a way of attaching data labels from a text range to dat. | Charts and Charting in Excel | |||
Using data as data labels | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Excel Discussion (Misc queries) |