Hi,
Attached sample file. There are 2 tables, they have same field names, one is % and otehr is absolute numbers. I need to cerate 2 charts (stacked bar) for % I did already. But when I add the Table 2 which has absolute numbers, the formating of the % chart goes for a toss as they have same filed names. How to rectify?
Thanks