Creating Charts

[oliver79]

Hi,

I wondered if someone could help me with the following scenario;

I’m running many advertising campaigns and therefore I have a workbook for each merchant I advertise for. Within each work book there are many campaigns (50+) for which I have one recap tab (see attached spreadsheet sample_data.xls). The main data I’m interested in displaying in a dashboard format consist of the following columns:

• Revenue
• Cost
• Profit

Now ideally what I would like to do is have one graph recap tab in each work book displaying graphs based on the above fields as per the attached example spreadsheet (dashboard_example.xls) – please see the following tab as an example of what I’m trying to achieve: Key Financial Indicators

However, anytime I attempt to build a graph based on the data columns I have the graph never looks correct; therefore, I would appreciate anyone’s assistance.

Many thanks