Excel 2007 Line Chart with Markers



  • 1. Display Horizontal and Vertical Line In Area Chart (Excel 2007)
    Hello, I have an area chart that shows workload in % (y-axis) over a year (x- axis). I am trying to add a horizontal target line to that at 100% and a vertical line that indicates today's date. I would prefer to show all charted data on the primary axis, since the XY chart doesn't go all the way to the top when placed on the secondary axis. I am trying to accomplish this in Excel 2007. I have found some great examples on the Internet to do one or the other in a chart, but so far nothing that indicates I can do both. Is it possible to add both lines in? Apologies for being so vague on the actual problems I am having, but in all my attempts so far, the chart has shown some very eratic behavior and crazy results, for example, all charted data (area and line chart) disappears, the data label for the vertical line disappears if I move the line from the secondary axis to the primary axis, oh, and my favorite one, Excel crashes alltogether. All help and suggestions would be greatly appreciated. TIA. Antje
  • 2. graph one minus graph 2
    Hi, I need to deduct 2 graohs from each other in excel. The sets of data used to create the graph have different x values so I can't just deduct them from each other and because they have been collected from a research project they have no regularity to create a function or trendline. Is there anyway to create this at all? ther are more than a thousand values so this can't be done by hand. Any help would be appreciated
  • 3. Charts - Setting Data Area as a Variable
    I have a set of monthly financial reports and associated charts. I need all the charts to show data just up to the current month. Up to now I have had to manually adjust the data area chart by chart at the end of each month as I move the model from one month to the next. What I need is to simply adjust one cell to state the new month number and this will adjust the data areas for all the charts. I have been experimenting with the OFFSET function plugged into the chart data range but it seems that this is not allowed. Can someone suggest an 'easy' way around this problem -- JohnG
  • 4. Excel: using data labels as markers
    I want to show the distribution of properties of products across two axes. Excel 2003 sp3, on Win XP sp2 How do I place the code numbers of the products at the coordinates, i.e. using text in a cell as the marker for each point? I used to be able to do this easily in Quattro, but cannot see a way in Excel. The following Help instructions do not work: "Reestablish links between data labels and worksheet cells Click a chart sheet or an embedded chart to display the Chart menu. On the Chart menu, click Chart Options. On the Data Labels tab, select the Automatic text check box. " because there is no automatic text check box Thank you

Excel 2007 Line Chart with Markers

Postby QmlzaG9w » Thu, 29 Oct 2009 23:24:01 GMT

I'm using a Line Chart With Markers tracking 4 data lines:
Red with Circles
Black with Squares
Blue with Diamonds
Yellow with Triangles

The yellow with triangles is very light and doesn't show very well in my PP 
presentation.  I would like to change the color of just that one line.  How 
do I do that?

RE: Excel 2007 Line Chart with Markers

Postby THVrZSBN » Thu, 29 Oct 2009 23:39:01 GMT

Click on that series in the chart, and right click, format series. You should 
now be able to change the color of the series.
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*

Similar Threads:

1.Problem adding vertical marker line to line chart

I have a line chart with date values on the x axis.  I want to add vertical 
marker lines on the chart to show when certain events happened (which do not 
correspond to dates for which there is data in the line chart).  I did a 
websearch and supposedly you can do this with something called the "series 
method", so I tried that.  It worked all right, except where my vertical bar 
showed up on the chart was nowhere near the date that I'd assigned to it; 
hence, not very useful.  I tried the "error bar method" and the results were 
even more ghastly and useless.  Is there a method for doing this that 
actually works?


2.Graphic Data Marker in Excel 2007 Charts


I would like to add some pictures as data markers in my line chart using 
excel VBA. I tried recording a macro to do this but the code is not generated 
for the insert picture part. Does any one have an idea for this.


3.automate 2dline with marker chart generation - Excel 2007

In generating line charts with markers, I can change the color of the 
markers, but not the marker lines and series lines.  The VBA code for the 
markers is:

   With Selection
      .MarkerStyle = xlDiamond
      .MarkerSize = 9
   End With
    .SeriesCollection(1).Format.Fill.ForeColor.RGB = RGB(255, 200, 25)

What are the references for the marker lines and the lines between the 
series points?

4.Alphabet in marker for chart lines

How can I insert a alphabet as marker in the chart lines.

If I right click on a chart line (line chart), then patterns, markers, then 
is there a way I can insert a alphabet or special symbols like "a", "c", 
"delta(greek symbol)" etc.,

Please help

5.C#: XYScatter chart with smooth lines and no markers

I hv been working on a Office 2007 App level add-in project using VS2005, 
.Net 2.0, VSTO for Office 2007 and Office 2007 Interopps. I want to draw a 
XYScatter chart with smooth lines nad no markers.

Why, even if we set the ChartType to xlXYScatterSmoothNoMarkers you get 
     xlChart.ChartType = 

Is there any way to change XYScatter line thickness?

6. Arrow on a line chart as a marker

7. How to change the spacing of data markers in a line/scatter chart

8. In Excel 2007 chart with multiple lines, mouse doesn't track lines

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 97 guest