Trying to generate charts showing Target and YTD analysis. Problem is that the records have diff units - excel has two columns that is Target and YTD and the rows are for - 1. Spend ( in INR), 2. Savings (in INR), 3. Efforts (in %) and 4. Content ( in %) . Can this be made available in one chart?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Excel charts
- Thread starter AB_Baby
- Start date
-
- Tags
- excel charts
Gerald Higgins
Well-known Member
- Joined
- Mar 26, 2007
- Messages
- 9,258
Hi, welcome to the board.
There are at least two ways to do this.
Probably the easiest way is to use two different Y axes for your chart, one on the left, one on the right.
So the one on the left could be for Spend and Savings, and the one on the right could be for Efforts and Content.
You can specify which axis to use for each data series.
The other way, is to normalise your data so that all data series start at a common point - say 100, and then you can track how they change relative to each other.
For example, let's say your Spend starts at 300, your Savings starts at 150, your efforts starts at 10%, and your content starts at 50%.
Divide ALL your spend data by 3, all your savings data by 1.5, all your efforts by 0.001, and all your content by 0.005.
Then use the results to drive your chart data, not your original source data.
All data series will then start at the same point, 100, but they will probably diverge over time.
There are at least two ways to do this.
Probably the easiest way is to use two different Y axes for your chart, one on the left, one on the right.
So the one on the left could be for Spend and Savings, and the one on the right could be for Efforts and Content.
You can specify which axis to use for each data series.
The other way, is to normalise your data so that all data series start at a common point - say 100, and then you can track how they change relative to each other.
For example, let's say your Spend starts at 300, your Savings starts at 150, your efforts starts at 10%, and your content starts at 50%.
Divide ALL your spend data by 3, all your savings data by 1.5, all your efforts by 0.001, and all your content by 0.005.
Then use the results to drive your chart data, not your original source data.
All data series will then start at the same point, 100, but they will probably diverge over time.
Last edited:
Upvote
0
Similar threads
- Question
- Solved
