Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create Array for Data Source
I'm trying to create a goal or target line that displays on a line
chart. In the past, I would create an additional row in my spreadsheet and enter the goal number (say, 80%) in every column. I've noticed in some chart examples a source data range that looks like {.80,.80,.80}. It made me wonder if there is a way that I can dynamically create an array (either in the chart source data or on the spreadsheet in a single cell) that adjusts in size based on the number of data points in the other data range. Any help would be appreciated. - John |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Create Array for Data Source
To draw a straight line, you only need two points, right? And if you're
clever, only one. Try the examples he http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "John Michl" wrote in message ups.com... I'm trying to create a goal or target line that displays on a line chart. In the past, I would create an additional row in my spreadsheet and enter the goal number (say, 80%) in every column. I've noticed in some chart examples a source data range that looks like {.80,.80,.80}. It made me wonder if there is a way that I can dynamically create an array (either in the chart source data or on the spreadsheet in a single cell) that adjusts in size based on the number of data points in the other data range. Any help would be appreciated. - John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question to Bob Phillips (or whoever...) | Excel Worksheet Functions | |||
Return Array with Array | Excel Worksheet Functions | |||
how do I create an array | Excel Discussion (Misc queries) | |||
What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |