I have a chart of values over time. I have 5 data series taken from a data table. The values come up in the chart OK but as I wanted to format the different...

Oh wise ones, I have a range that is dynamically updated by a SQL call. The data is changing every 2 seconds. The routine is populated by a calulate sheet...

I have a chart that starts incrementing at 5,000. Is there a way to truncate say between 0 - 25,000 (and perhaps show it as a broken bar graph, like other...

I have a chart now with this in the data range: =PHQChartQuery!$A$2:$C$7 But I would like it to look like this =PHQChartQuery!$A$2:$C$500 But when I do there...

How can I built a line graphic (one serie only) that as under the line a coloured area without hiding the X and Y gridlines?

Abr Mai Jun Enc. Auto 58% 54% #DIV/0! Enc. Semi 30% 31% #DIV/0! Manuais 12% 15% #DIV/0! I have this table and i want to do a chart type Area. I don't have...

The main chart has lots of data points (300 )and I want to create a secondary y axis showing daily mean max min temperatures with only 7 data points. The...

In Excel you can easily make "column-diagrams" (if that's the right word?) to point right or up. How do you make them point down or better yet, left?

Is there any way to total rows and/or columns in the Data Tables that can be added to Pivot Charts (Table Options)?? I can obviously get the totals in the...

Excel 2003 is plotting any type of graph I select in reverse order. I am selecting data ranges normally, yet Excel is creating these upside down graphs. I...

I have am using a bar graph and one bar is off the scale. In the 2003 version of excel the label for that bar becomes invisible, in older versions I could...

Good day! I have been trying my best to do a column-line combination chart using a stacked column charts and with 5 lines with points at each end in excel...

Help, How do I switch (change) info from the axis's and legend around? How do I move info from the axis, if I want - to the legend, and then move the legend...

When a chart is based on a formula e.g. =IF(A1=0;"";A1*B1) then the chart will show the blank value "" as zero even if you whant to plot gaps or plot the empty...

I am trying to create a bar graph in excel that has a gradient color scheme that goes from yellow to red as the predefined severity of a risk increases from...

I am creating a set of worksheets analyzed with pivot tables and charts that track time delays in starting office procedures. Some of the procedures...

I need help. I have a chart with multiple columns and three rows. Each row has a total. I would like to do a stacked column chart shoeing the each...

I have a chart created by an intern last year, the data to create the chart was in a file stored in their temp files and is now lost. When I open that chart...

Is it possible to refer to a holiday list somewhere in my windows installation when I work with the function =WORKWEEK? If not, can I collect the holiday lists...

Hi, I'm having problems with certain data labels on columns within a chart, where the column reflects the correct data, but the data label contains...