VSTO Excel chart type?

Question

Currently I have consturcted a chart that shows a line for each column. The chart has a median column, upper 80% column, upper 95% column,  lower 80% column, and a lower 95% column. This works just fine using

Excel.

XlChartType.xlLine

Now I would like a line showing the median, with shading up to the upper 80% and down to the lower 80% of one color, and shading from median to upper 95% and down to lower 95% another color. Since the upper 95% is always greater than upper 80% the shading showing the 95% levels would only show up between the 80% and 95% levels. The xl3DStacked type almost gets me there but the 3D takes up too much room and there seems to be multiple colors that I don't want. xlLineStacked seems to change the display of the data in a way that I am unfamiliar with. Maybe "stacked" assumes that the columns are deltas. I don't know. Any suggestions for getting the chart look that I described?

Thank you.

Answer 1

Hi Kevin

The VTSO forum supports questions related to the VSTO technology. Your question asks how to do something with an Excel chart. VSTO does not extend or work with charting in any way. Therefore, you're unlikely to find any support in the forum for charting issues. I recommend you use the resources in the forum's Please REad First message. There's a link there to a group that specializes in charting.

---

Cindy Meister, VSTO/Word MVP

Answer 2

Sorry, I read the message and I couldn't not see a specific link to a charting group. Would you mind being a little more spcific?

 

Thank you.

 

Kevin

Answer 3

copied from the message:

EXCEL

• Charting issues: excel.charting newsgroup
   http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.charting&lang=en&cr=US 

 

---

Cindy Meister, VSTO/Word MVP