in EXCEL - I want to have line chart showing Planned vs Actual over time (weekly). I have 5 data points for Planned. I want to show Actual results only when...

In my job I very often create charts from excel data. Then transfer that to a graphics program to add more and better graphic styling. Then embed this into...

Hi, I am curious to see if anybody could create a visual relationship between a point on the chart and the data cell. Let's say if we have 1000 points on the...

Hi If I have raw data, then I understand the method of doing Histogram with Excel. What is if the Histogram is already presented in a Table and I have...

Hello guys, I Don't want to bore you with details. I have Excel spreadsheet which I would like to be accessed from any PC with internet connection. What I...

How do I get a surface chart to plot empty cells in white rather than in the colour that the chart uses to display 0 values?

I have means of values that are in a line chart. I want to add error bars, however when I add the error bars with SD=1 they all look the same. I know the SD...

I am trying to fit two sets of data on the same chart to make an acid/base titration curve. I need the horizontal axis to could from 0 to 25 then back to...

I want to draw a decision tree flowchart in Excel. Hence I need to write on the connector/line that links two boxes. e.g. I want to write 'YES' and 'NO' onto...

I have a time-series line chart I am plotting at changing frequencies depending upon user input. Under the Axes option, I am using 'Category', so as to...

I have a chart which pulls data from various worksheets. The data changes monthly, so each new month there are lots of blank cells which don't yet have...

Using Excel 2003. I have a data range for a graph. The values in the cells are the results of a simple If function - If(m280,n28,0). The results are taken...

When I make a chart with a logarithmic axis (a xy chart with the y axis logarithmic) I cannot get the minor tick labels plotted on the logarithmic axis (I can...

Hi, I have a simple pivot table with two columns A and B against several rows of responses. The pivot table also shows the Grand Total Column. I can graph...

Hi! I often make charts based on pivottables. In some cases i would like to include totals from the pivottable in the chart but i dont know how to do this....

Does anyone know how to include extra data in the graph table that is attached to the graph, without actually plotting this extra data on the graph? For...

I want both the comparative of a clustered chart and the make up of a stacking chart incorporated into thew same area...any ideas?

I would like to incorporate and display the percentage of the data series in the Data Label of Column chart. Can anyone help me in this regard, by giving a...

in X-Y scatter chart i am having problem of text fitting the title box of Y axis title. Neither I can increase it manually, not through clicking menus. Any...