Exporting Bar Chart data to Excel

[RussTypeS]

Like the topic says, I would like to export the results of a Bar Chart to a csv file. If nothing else It would be nice to have the crosshairs show up with the box to tell you the exact value for each bar.

If you could do the copy-paste trick with bar charts like you could with xy graphs, that would be perfect..

If anyone knows a way to do this in excel using the standard export data, that would be very helpful...

[Support]

there is no way to di it directly... obviously you can export any range of data using the data export window in v6.

Support

[RussTypeS]

there is no way to di it directly... obviously you can export any range of data using the data export window in v6.

Support

The problem is calculating frequency % in excel, AFAIK there is no way to do that. Any chance of an enhancement for a future version?

[Turby]

What do you mean by "frequency %" ?

Its easy enough to create your own bar charts in excel... just export all samples of the relevant channel into excel and then use the chart wizard to create the chart accordingly.

[RussTypeS]

A picture is worth 1k words...



It shows what percent of the time I'm at what speed.

It can't be too hard to add functionality to do this, considering you can do it with the xy graph...

[Turby]

IUsing excel...
http://www.geocities.com/calculatorhelp ... ograms.htm

You might need to change from frequency as a count to frequency as a percentage of total counts. Just create another coulm and divide by the total sum data items. Format cells to show as percentage.

HTH

[RussTypeS]

IUsing excel...
http://www.geocities.com/calculatorhelp ... ograms.htm

You might need to change from frequency as a count to frequency as a percentage of total counts. Just create another coulm and divide by the total sum data items. Format cells to show as percentage.

HTH

That's perfect! Thanks!