Displaying Trendlines Only in a chart | MrExcel Message Board
Jun 20, 2003 · Excel allows me to easily create trendlines for each line in the graph, but I can't figure out how to display the trendlines only; if I select the original line and delete it, the trendline disappears …
Remove Chart with VBA | MrExcel Message Board
Oct 28, 2006 · I have a simple (but frustrating) task; I'm using a macro to create a chart on a worsheet and I'm looking for a simple macro to delete the same chart in the same worksheet.
Chart showing max. of 120% instead of 100% - MrExcel
Jul 13, 2006 · Not sure if I worded the topic title correctly but a bar chart I have created in Excel 2007 shows a maximum of 120% even though none of the source figures are more than 100%. The …
VBA to delete chart image in Word | MrExcel Message Board
Jan 16, 2018 · Hi community. Hope you can help a VBA novice. I've found some VBA code which enables charts in excel to be pasted in to a Word doc. See code below. I want to enhance this further …
Deleting a point from a scatter plot | MrExcel Message Board
Sep 16, 2009 · I envision creating a macro, say, "Delete Points", which, upon activating, would enable me to put my mouse pointer over the desired point and when I press the left mouse button, the point …
Delete source data, keep graph | MrExcel Message Board
Nov 28, 2005 · In Excel I have 2 sheets, called 'sheet1' and 'sheet2'. In sheet1 is placed a graph, the source data for the graph is placed in sheet2. Now what I want to do is to delete sheet2 (the source …
How to get Chart Legend Back if Deleted - MrExcel
Dec 24, 2011 · So i deleted a chart legend - is there a way to get this back or do you have to start all over again?
Hiding part of line in a line graph | MrExcel Message Board
Apr 4, 2005 · Hi All, I'm using Exel 2007. I'd liked to hide a line in my line chart. I have the months for the year (in this case 2013) and i have data from Jan - Sep so chart as a line from Jan - Sep. But then …
Delete series from a Chart Using VBA | MrExcel Message Board
Feb 22, 2008 · Hello, I have a chart that is created using VBA. When my data is updated I would like to delete all of the series of the chart and creatre new ones. I have a macro running triggering the new …
VBA Clear Chart Dynamically and refresh with new values
Nov 16, 2009 · Hello, I have a chart named "VelChart". It fetches data from a set of dynamically created cell values. However, I want the chart to be cleared of any graph every time I said referenced cell …