formatting charts

Hi! I have created a graph which compares three measures. As I let the users choose the measures, the third measure can be either numbers or percentages. I used conditional formatting to adopt correct formatting. When I created a chart from this and linked the third measure to secondary axis...

Hi everyone. I hope someone can help me; this problem is driving me nuts! I have designed a dashboard containing 2 pie charts and a bar chart. Each of these charts has data relating to the same series. I have used the same color-coding for the series in each chart to help visually link them and...

I was wondering if there is a way to make a Stacked Bar Chart automatically order the segments within each bar as data is added. For example, I am working on a personal finance project where my stacked bar chart has a category (x-axis label) titled "Food" and subcategories "Restaurants" and...

Hello, I am a loss. I wrote a Macro to reformat a Chart Tab in a very specific format. I have two problems. The first is I must run the macro twice for the format to be correct. The plot area is fixed on the second running of the macro. here is the code in all it's glory and yes it needs...

Hello all, I have a tool designed to work in excel 2010 and excel 2007. In the tool there is a generate pdf button allowing the user to output a pdf of various graphs and tables created in the tool. In excel 2010 this works well, however in 2007 the graphs become unaligned and some become so...

I was trying to improve the look of my combo chart, which has columns for one series and lines for 3 other series of data. I did a great job of getting it into tip top shape so that data labels were called out above the lines, the lines color coded, the numbers were black....I made sure to Save...

Hi all, This is a two-parter I guess. Is it possible to set the colour of an individual data point in a sparkline graph? If so, is it possible to set the colour based on criteria, for example above a certain threshold? I'm hoping to use sparks to display how a set of measures are performing...

:confused:Not sure if anyone can resolve this issue, but any suggestions are welcome! I can send an example upon request, would be nice to be able to upload for reference, but please read entire post. I have a stacked column chart (two series)to show a start point ($5000) and 9 option...