• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

creating an excel chart

Hi I have attached an excel chart. I want to create the chart when I can get all the accounts together, all the mob together and all the economics together....not separated as you see it now....

can someone help me do this??? so in the different years you see how one subject did throughout and you do it for all those 3 subjects fir the years 2009-2012
Cape-Results-compared-2009-2011.xls
0
slingingshot15
Asked:
slingingshot15
  • 2
1 Solution
 
ScriptAddictCommented:
This is a little misleading.  When I look at the chart the year isn't lined up with the correct data.  I'll include 2009 through current.  So one extra set of bars.  I'll have your chart in just a minute.
0
 
slingingshot15Author Commented:
ok thanks and please explain to me how u did it as well...thanks
0
 
ScriptAddictCommented:
Ok,

Here it is,
you'll notice I did a little data reorg off to the side that I used for the combined bar chart.  

It was just a lot more difficult in the format you had to get a chart to work by swapping axis.  

I've linked it all so it should auto update.  

Let me know if you have any questions.

I included some other options as well.  

-SA
Charts.xls
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now