Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automate charting question!
I have a table of a set size that contains data generated by some vbb code by
the user. However, on each time the user runs the code, some of the rows will contains the value "x" - which in this case signifies and empty cell. I am tring to display the data in a pie chart, but each time new data is put in the chart and legend require re formatting to get rid of the x's... it looks kinda like this: - two columns, lhs is the no. , rhs is the label % cntry 5% UK x x 2% USA 10% FRA x x x 12% Other and so on.. thing is, which cells are x and which cells have thecontent i want to graph change each time! is there any way i can get a graph to incorporate this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditinal Formating question | Excel Discussion (Misc queries) | |||
Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Charting time? help please... | Charts and Charting in Excel |