Is it possible to have an export in excel with alternate colors for the rows.

How do i update the Legend data on a Pie Chart. I have argument data column as the grouping, however it just shows the %. Please view attached. I don't need the %, I need the grouping that makes up the %.

I would like to show the notional value of a Debt Ticket on first most row. The report has multiple rows, I want to show the value on the first row and not have it repeat.

Is there a way to export an Excel report with no gridlines?

Ok forget it that worked thanks

I tried that but it still won't save.

I don't get it. If I don't use a data band and just insert a chart I get no data. If I input the chart in a Databand it repeats the same data as many time as my group. In my group I have different currencies.

I'm having difficulty changing color on bar chart. When I change the color it doesn't save it

Hi
I inserted a chart in a Data Band and am grouping by a trade ccy. For some reason the chart repeats itself, I believe it's for all the currencies. I just want the 1 chart. Please view attached the multiple chart export.

perfect thanks