• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating a chart

TanuDewan

New Member
Hello, I have mentioned the problem I am facing in the attached sheet. Please revert asap.
 

Attachments

  • Excel_1.xlsx
    11.1 KB · Views: 0
Hi TanuDewan,

It's best to give us as much information as possible about what you wanting. To just make a chart, select range B6:R14, and make a column chart. That will make a nice colored chart like this:
upload_2015-6-3_11-7-50.png

If this isn't what you want, please describe in more detail what you would like to see. All you gave us currently is "...for each sector the total ict market and addressable market overlap with each other."
 
Hi TanuDewan,

I agree with Luke M that you need to provide a bit more information about the chart you want. Plotting all data into one chart is probably not the best approach, since there will be too many data points.

Do you want to see how one sector changes over several years? Or do you want to compare all sectors for one year?

cheers, teylyn
 
Hi Luke ,

My guess is OP is looking for a chart like this , where the two columns for the two categories overlap.

Narayan
 

Attachments

  • Excel_1.xlsx
    14 KB · Views: 1
Hi Narayan,

It's a good guess in terms of layout. If OP responds, I'll be curious as to what they really wanted. :)
 
Back
Top