How to export chart and related info into a file

[#1]

Hi All,

How to export charts and related info into a file?
Thanks in advance.

[#2]

we can export chart in many ways like we can export chart in Image file or export only chart values to the excel.

We can also export chart as Image in excel or pdf or in ppt through Macro.

[its_anandrjs]

Hi,

You can use macros for this for exporting the Charts objects and other related info to any folder and then use that for your any other files like PPT or Doc files

Ex:-

Sub ObjExportToFolder

GraphPath  = "C:\MyObj\"

ActiveDocument.GetSheetObject( "CH01").ExportBitmapToFile GraphPath & "FirstImage.jpg"

ActiveDocument.GetSheetObject( "CH02").ExportBitmapToFile GraphPath & "SecondImage.jpg"

ActiveDocument.GetSheetObject( "LB01").ExportBitmapToFile GraphPath & "ThirdImage.jpg"

End sub

By this example CH01, CH02 (Chart1 and chart 2 are export) and LB01 (List box 1 is exported) you can add more here by your use.

Regards

Anand

[ngulliver]

Are you looking to do this regularly as part of an automated process ? If so, I would look at NPrinting which can produce excel, ppt, word, html or Pixel Perfect files depending on your need.

If it is a one-off, try Anand's macro.

Regards,

Neil

[#5]

Hi Neil,

I wanted to use this info to create the charts in my personal edition as license is going to expire soon.

[its_anandrjs]

Yes you can do this there on the dashboard press Ctrl + M and write the macro code there and but be insure you have correct folder name and Object Id used in the macro.

Sub ObjExportToFolder

GraphPath  = "C:\MyObj\"

ActiveDocument.GetSheetObject( "CH01").ExportBitmapToFile GraphPath & "FirstImage.jpg"

ActiveDocument.GetSheetObject( "CH02").ExportBitmapToFile GraphPath & "SecondImage.jpg"

ActiveDocument.GetSheetObject( "LB01").ExportBitmapToFile GraphPath & "ThirdImage.jpg"

End sub

Regards

Anand

[#7]

Hi Anand,

I want to export which dimensions, expressions and variables are used for chart1, chart2,... so on.

I want to do this task in a single time without giving chart ids. How to do it?

[its_anandrjs]

Hi,

There is another way you can do is create a straight table or Table Box and add the System Fields on that chart for complete fields which is in your model.

1. Add all fields on table box and use this for exporting the excel file or JPG image for reference.

2. For Expression you can use variables instead direct writing expression assume =Sum(Sales) in place of this use variables like

vSum = Sum(Amt) //Without equal sign.

And in chart use it like

=$(vSum)

And for exporting add the variables into input box and export this also.

Regards

Anand