![]() I’ve added some smarts so it uses the selection as the default for the source data range in the first input box. ![]() The code uses a couple of input boxes to get the ranges from the user. Since I always align my charts with the cell boundaries, this is nicer than the Chart Wizard in Excel versions up to 2003 and the Insert Chart command in Excel 2007. The VBA procedure (code below) actually works a bit like my first recollection of Excel charting, which had two dialogs, one asking for the data range, the other asking for the range of cells to cover witth the chart. I’ve taken an example from my web site, Interactive Chart Creation, and embellished it a bit. That’s not built in, but it’s not hard to do if you know a little VBA. Someone asked in the newsgroup how to create an XY chart in Excel that uses the label at the top of the columns of X and Y data for the axis titles.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |