How to automate data range on excel chart?

Answer When creating a Chart, there is problem with specifying a larger area of cells than there exists data. You could end up with a large portion of the graphed data being blank (the cells with no data... Read More »

Top Q&A For: How to automate data range on excel chart

How do I drag chart markers to change data in Excel 2007?

Drag Chart MarkersAdd new data to the Microsoft Excel 2007 spreadsheet in the rows and columns adjacent to the existing rows and columns of data. Click the chart to select it. Sizing handles appear... Read More »

Is there a way in Excel 2003 to get the source data of a chart(VBA please), I can't find how to do it?

I wished I knew more about what you are attempting to accomplish, and why you want that particular range. It would assist in finding you a way to solve your current problem.There is no GET method ... Read More »

Excel: Automatically generate balloons or other annotations in a chart from text fields in the source data?

Comments and other such annotations are not really part of Charts. And a comment is a note that you attach to a Cell, separate from other cell content.Even using a separate column to hold text to ... Read More »

How to Use Microsoft Excel to Name the Range of Data That You Want to Import?

When working with data in a worksheet on the Microsoft Office Excel application, you import data from Excel workbooks and other applications. For example, if you have a chart you want to import int... Read More »