As computer scientists we are trained to communicate with the dumbest things in the world – computers – so you’d think we’d be able to communicate quite well with people. I was able to get the labels into the body of the graph. Given that idea, you would have to paste a text box or somethin over the default labels with your desried text.
And also is there any way that i can plot data labels on the graph because i have a doubt about this also as it picks the value from the x-axis as well. Is it is so that exact date value can't be plotted on the x-axis. Graphical representation of the data can help the viewer. Depending on which data is used, the scaling options are limited compared to the scaling options of the Scatter chart's x (value) axis. Excel sheets usually contains a lot of data and in order to go through all that data it takes time. The x-axis of a Line chart can be either a category or a time axis, both of which can display non-numeric data. To display this numeric data with greater flexibility, you can change the scaling options on this axis. This initial graph should look like the one shown to the left. From the Charts group on this tab, select Column and then pick the first entry (Clustered Column) of the 2-D Column choices, as shown in the image to the right. This means that only numeric data is displayed on this axis. With the data still selected, click on the Insert tab of Excel’s main toolbar. The x-axis of a Scatter chart can only be a value axis. Dim Counter As Integer, ChartName As String, xVals As String Application.ScreenUpdating False Dim c As ChartObject Set c Sheets('IImpactchart').ChartObjects('Chart 1') c.Activate xVals ActiveChart.SeriesCollection(1). Scatter charts and Line charts also differ in the way they use axis types and scaling:
How to create scatter chart in excel 2007 series#
Each data series in a chart has a unique color or pattern and is represented in the chart legend.
I believe I tripped over the answer to your problem: in a scatter chart the X axis can only have numeric valuesīut i went through an MS Office link for creating XY (Scatter) and Line charts. Add or remove a secondary axis in a chart in Microsoft Office Excel 2007 When the values in a chart vary widely from data series (data series: Related data points that are plotted in a chart. Try on Layout tab / Labels group / Data labels drop down / More Data label options: In Label Options option / Label Contains: X value, Label Position Right
I found this tipe, but it doesn't work in my 2007 installation, the specified option is not there. Chart type /sccater chart, #3 in the list o fchoices This chart shows labels similar to what you want:Ĭhart addition of Axis Titles and Data Labels:.
0 kommentar(er)
