Hi guys
In attached sample file I am trying to create a trend chart...
Pretty sure this is basic but I just can't get it to work...Works when values are numbers but not percentages...
What am I missing...
Hi guys
In attached sample file I am trying to create a trend chart...
Pretty sure this is basic but I just can't get it to work...Works when values are numbers but not percentages...
What am I missing...
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
Works, but the percentage format is just a format not number.
In fact, under the percentage format 100% is "1", 85,5 % is "0,855" - "orders of magnitude" smaller numbers.
Last edited by mjr veverka; 03-10-2018 at 10:25 AM.
Hi porucha
So...What can i do to make it work? The percentage values are extracted via code
Edit...Not to worry ...Changed the 1 2 3 4 to term 1 term 2 etc
Last edited by Sintek; 03-10-2018 at 11:15 AM.
Sorry, but it seems I didn't quite understand the subject.
Regarding the value to "Term", did you try to set the value of this column programmatically in the chart ?
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks