How to insert or have a Small text box in Chart

[ranjithParticipant]

I dont know why this one is not one able to solve it i have posted couple of time in various blog

Currently i have requirement need to have label in Excel charts

Please let me know how to do this ,

I am dont want use in interoperatiblity because of performance issue , please guide how to do in open excel or EEPLUS any XLSX version

Charts
Thanks

1000 thanks return

Ranjith

[Eric WhiteKeymaster]

Hi Ranjith,

This is one of the areas where we do not currently have enough content – that explains how to create charts for XLSX using the Open XML SDK.

Are you comfortable, in general, with creating and modifying Open XML documents using the Open-Xml-Sdk? You need to be familiar with creating markup and creating parts, where the parts have a given content type, and creating relationships between parts, where the relationships have the appropriate relationship type.

The approach that you need to take is to create a spreadsheet that does not have the desired text box, copy it, then in the copy, add the text box, then use the Open XML SDK Productivity Tool to determine the differences between the two. This will teach you about the markup you need to create. See the following screen-cast:

Screen-Cast: How to Research Open XML Markup

Beyond that, I recommend that you watch the various screen-casts that are an introduction to Open XML:

See the screen-cast series in the sidebar on this blog.

[Author]

Posts