| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to turn of a series in data sheet of a power point chart using macro
Hi I am writing a macro to automate the power point presentation assigning values to data sheet(chart) from a excel sheet.on one instace in a bar graph, i have like 100 bars to be diaplayed and when i add values to the datasheet the graph looks so messy. Is there any way that i can disable a range and show only a certain range by a macro.I know i can do it manually by opening the data sheet and double clicking the column header to enable the whole column and disable it Can anybody help me in providing the tip. Many thanks in advance Regards Chepyala -- chepyalarr ------------------------------------------------------------------------ chepyalarr's Profile: http://www.excelforum.com/member.php...o&userid=31103 View this thread: http://www.excelforum.com/showthread...hreadid=507708 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Show series name on the chart - but not at every data point | Charts and Charting in Excel | |||
| How do I alter the value of a data point in a chart series | Charts and Charting in Excel | |||
| How do I make the data sheet appear in my power point presentation | Excel Worksheet Functions | |||
| Import chart to Power Point and Macro problem | Excel Discussion (Misc queries) | |||
| Challenge...Excel Chart to Power Point | Excel Programming | |||
Threaded Mode
