Hello.
I created a line chart where some part of line chart is increasing and some part is decreasing. Is it possible to to separately format only the part of line chart which is decreasing?
Example available here.
Regards
Jan
Hello.
I created a line chart where some part of line chart is increasing and some part is decreasing. Is it possible to to separately format only the part of line chart which is decreasing?
Example available here.
Regards
Jan
in your chart only one row mentioned "suma" (i think those are part line name). which part of line wants decreasing?
This is a your actual data table?
Hi avk.
I updated my chart example with expected chart result, please redownload my example here
The standard approach to "conditional formatting" of charts is similar to this approach by Jon Peltier: http://peltiertech.com/conditional-f...-excel-charts/ Note that most of the work is in the spreadsheet, where you separate the increasing parts and the decreasing parts into separate ranges so they can be added to the chart as separate series.
Originally Posted by shg
Thank you MrShorty for your help. You gave me a good idea how to resolve it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks