LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Bas Avel
 
Posts: n/a
Default Comparing incomparable

I want to create a simple (bar) chart where there would be sales compared
with number of shops compare with sales of chocolate compared with net
profit/shop

Of course such a chart would look terrible since the it would compare e.g.
16 shops with $ 6 800 000 of revenues with $ 35 000 of net profit per shop.
Is there a way to put it into one chart? the number of shops will be almost
an invisible bar while revenues will sky rocket - with such a chart (though
precise) it would be difficult to illustrate the market conditions in the
range of say, 3 years.

Or to put it in plain English: I want to see the relationship between
apples, pears,phonecall , flowers and rainfall though they would show a
different values since they are measured in different units ( $, kg, m3,
hours).
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Comparing Data between two sheets AChesley Excel Worksheet Functions 1 February 17th 05 02:02 AM
Comparing Data in 2 columns suzb Excel Worksheet Functions 2 January 6th 05 02:39 AM
Nested IF Function, Date Comparing, and NetworkDays Function carl Excel Worksheet Functions 2 December 29th 04 09:57 PM
Formula for comparing text in two workbooks Bob Excel Worksheet Functions 2 December 9th 04 08:45 PM
Comparing Data in two columns Marianne Excel Worksheet Functions 3 November 5th 04 10:26 PM


All times are GMT +1. The time now is 10:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"