Chart in Excel and Access

[Guest_imported]

Hi,
I’m using Excel to create Line Chart type and now I want to use Access to create it. In Excel, for example I have 3 row of data type. First is Apple with 1, 2, 3, 4, 5 and second is Orange with 2, 3, 4, 5, 6. Third one is the total of Apple and Orange. When I create the chart, I just highlight the Apple, Orange and Total with all the data, the chart will give me 3 lines. In Access, I do not have the total row. Can I do something so the total line will appear at the top of the chart with the total of apple and orange. May be I need some formula or VBA I do not sure, can somebody help me on this??

Thanks in advance,
Need help