Type of charts from Access
 

Hello!!!
I'm sending dynamicly created table from Access into the Excel and making
chart using VBA. By default I'm getting Column type of chart, where acctualy
I need to leave users the choice, including Line and Pie charts, primarly
line. How do you suggest I do that? In VBA, how do I adress those types of
charts? Maybe this is question for Access group, but I wanted to try here
first.
Thanks for your help!
Ana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200906/1

Type of charts from Access
 

Use a box like a list or input box

Response = InputBox("Select chart type" & vbCrLf &
"1 - Line Chart" & vbCrLf & _
"2 - Scatter Chart" & vbCrLf & _
"3 - Bar Chart")


"Ana via OfficeKB.com" wrote:

Hello!!!
I'm sending dynamicly created table from Access into the Excel and making
chart using VBA. By default I'm getting Column type of chart, where acctualy
I need to leave users the choice, including Line and Pie charts, primarly
line. How do you suggest I do that? In VBA, how do I adress those types of
charts? Maybe this is question for Access group, but I wanted to try here
first.
Thanks for your help!
Ana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200906/1

Type of charts from Access
 

Aline continuation character got lost

Response = InputBox("Select chart type" & vbCrLf & _
"1 - Line Chart" & vbCrLf & _
"2 - Scatter Chart" & vbCrLf & _
"3 - Bar Chart")


"Joel" wrote:

Use a box like a list or input box

Response = InputBox("Select chart type" & vbCrLf &
"1 - Line Chart" & vbCrLf & _
"2 - Scatter Chart" & vbCrLf & _
"3 - Bar Chart")


"Ana via OfficeKB.com" wrote:

Hello!!!
I'm sending dynamicly created table from Access into the Excel and making
chart using VBA. By default I'm getting Column type of chart, where acctualy
I need to leave users the choice, including Line and Pie charts, primarly
line. How do you suggest I do that? In VBA, how do I adress those types of
charts? Maybe this is question for Access group, but I wanted to try here
first.
Thanks for your help!
Ana

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200906/1