I was thinking to load the chart image into the Data point marker, but i don't think that is the best way as the data is updated daily and I would have to do it each day for a few line charts. I have a line chart that displays the total by date, but I want to find a way to display the percentage split of a particular day by type. These are recorded per day (Date, in Column A) My database has 3 value columns, Type1, Type2 and the Total (Type1 + Type2) I am looking for a creative way to display a pie chart within a data point marker of a line chart. View 1 Replies View Related Excel 2010 :: Add Pie Chart Into Data Point Marker On Line Chart Nov 27, 2011 as switching on minor grid lines, included those at the integers as well as at the half way points. but I want to show minor grid lines at 0.5, 1.5, 2.5, and 3.5 only. View 13 Replies View Related Excel 2010 :: Grid Control On Scatter Chart Jan 14, 2013 However, I want to shade some of the cells with darker and lighter shades. The "x" and "y" axis both start at 0 and go to 4. 2) The scatter chart appears with gridlines as a 4x4 matrix with a total of 16 cells. It will not list the single supplier listed in cell D4. The scatter chart will plot the points correctly, however, there are two issues: 1) If I try to insert a data label using the "Series Name," or in this case, the supplier's name, it will lists ALL of the suppliers Column D. The "y" value is listed in Column F starting in cell F4 thru F7. The "x" value is listed in Column E starting in cell E4 thru E7. There are 4 suppliers listed in Column D starting in cell D4 thru D7. I'm working on a criteria matrix in Excel 2010 that automatically plots a single member in a Scatter Chart based on the two values.