LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 5
Default Chart Data Normalization

Hi. I have two columns of data relating to two products. I would like to
'normalize' the data so that in graph format, they both start from the same
point giving a realistic comparison between the movement of both. The data
is as follows:

ColumnA ColumnB
1.09% 24.00%
-0.11% -2.03%
-1.95% -0.13%
-18.54% -14.99%
-13.92% -15.56%
-31.25% -27.62%
-17.57% -23.33%
-9.63% -16.19%
-5.78% -11.19%
6.78% 5.33%
4.45% 10.55%
-4.95% 4.40%
10.23% 13.59%
1.84% -4.24%
7.73% 9.89%

Is this possible please?
Thanks
Yvonne
 
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
chart from pivot data does not update x-axis bar chart values - bug jason gers Excel Discussion (Misc queries) 0 April 3rd 07 06:34 PM
How do you link chart source data when you copy the chart? mamagirl Charts and Charting in Excel 1 December 8th 06 02:40 AM
Resizing chart because of refreshing Chart Data through a query jayb Charts and Charting in Excel 0 August 10th 06 04:21 PM
Question on Data Normalization adachan Excel Discussion (Misc queries) 0 July 27th 06 09:30 PM
Normalization Jar New Users to Excel 2 October 17th 05 05:03 PM


All times are GMT +1. The time now is 07:34 PM.

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"